Here is my question requirement go through the topic and let we discuss this!
The requirement is to flag the incoming record from source to target as I, U, D, I-insert, D-Delete, u-Update. Source and target are various RDBMS system.
Using lookup on scd type1 we able to achieve I and U flag. Since the lookup is based on equi join of the primary key it was a challenge to flag the deleted record. Not able to use left or full outer join
Your inputs are highly appreciable