Skip to Content
0

is there any way we can implement SCD type 2 with out using TC, HIS,Key & Lookup condition too.

Apr 23 at 10:01 AM

28

avatar image

Hi All,

Could you anyone help me how to implement SCD type 2 with out using TC ,History prevent ,key generation. i dont want use even Lookup conditions also.

And please let me know performance when we have huge records.

Thanks in Advance !.

Regards,

Priyanka.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Priyanka Choudam Apr 24 at 08:57 AM
0

Hi Vibhor,

Thanks for Response.

Let me try your suggestion and let you know the performance.

Thanks!.

Share
10 |10000 characters needed characters left characters exceeded
Vibhor Gautam Apr 23 at 05:13 PM
0

Hii Priyanka, Yes it is possible to implement SCD Type 2 without TC but key generation requirement depends on whether your business logic is demanding new keys/surrogate keys to be generated or not. Those keys should get incremented by a constant.

It depends how you want to achieve it. You can use Case transformation after Query transformation.

source-> query tr-> Case transform-----now distribute into 3 query transformations 1) Insert new records 2) Update records 3) Discard -> 3 Map operations to change the opcodes -> Attach target table 3 times in respective order.

It should be something like this. Use query transform as per your logics.

Share
10 |10000 characters needed characters left characters exceeded