Lookup duplicating records

Records are duplicated in the job (even if the flow is not duplicated in datastage!).


Cause - It was due to the Entire partitioning having been defined for the primary link in the last lookup stage.