make source and target to be sync in informatica

Question

I have a scenario where

1st run: 500 records loaded to target from Source.

But for 2nd run you get 450 records from Source,

The target and source are to be sync for each run,

how do you sync i.e delete the extra 50 records in the target? in Informatica PC/IICS.

Answer 1

Just truncate the target table at the start of the run

Answer 2

Truncate would be the best option, if the delta between the source and target is in millions. But in case if the delta record-set between source and target is small then you could add index on target and with the help of lookup, validate if the record is addition or deletion and perform the relevant action.