Submitted Questions

  • In scd type2

    Is it possible to use SCD Type-2 without using Lookup in the mapping?If it is possible please let me know. How it will be possible?

    ashwin

    • Mar 22nd, 2017

    SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records) SRC(TGT)-->SQ--> -->TGT(Update The entire implementation will be same as that using a l...

    ashwin

    • Mar 22nd, 2017

    The entire implementation will be same as that using a lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table w...