Skip to Content

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Apr 24 at 08:57 AM

    Hi Vibhor,

    Thanks for Response.

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

    Thanks!.

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 23 at 05:13 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded