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

[former_member290153]

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.

[former_member290153]

Hi Vibhor,

Thanks for Response.

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

Thanks!.

[vibhorgautam]

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.