MAHESH MANAM

• Sep 17th, 2012

 

As of my knowledge we can do SCD Type 2 by using joner transformation.
First take the source and target(i.e which is target) as source and join these two by using surrogate key like master outer join(take source is master and target is detail).
If any match found than do update the record or reject record based on check the remaining columns if any thing is changed.
No match found than do insert for that row.

Anupama

• Oct 8th, 2012

 

we can use SCD without using lookup.

Mahendra Rajpoot

 Profile Answers by Mahendra Rajpoot 

• Sep 17th, 2014

 

Yes it is possible. Use left outer join query between source and target table in SQ to achieve look up functionality. Send this output to EXPR and then RTR for condition check SCD 2. Then insert and update Target based on RTR conditions.

Query will fetch all records from Source and only the matching records from target.

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 will be used as Master and the Target table as Detail. The join condition will be same as that of lookup condition and the join type being Detail Outer Join
SRC-->SQ--> JNR-->EXP-->RTR-->TGT(Insert for both new and updated records)
SRC(TGT)-->SQ--> -->TGT(Update

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 lookup. The only thing we need to replace the Lookup transformation with a Joiner transformation. In the Joiner transformation the Source table will be used as Master and the Target table as Detail. The join condition will be same as that of lookup condition and the join type being Detail Outer Join