Flag Insert Update and delete source record in target using informatica

modeling

(Nicole Wells) #1

Hello All,

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.

Source - Oracle Target - Greenplum

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