Saturday, March 16, 2013

How to Delete duplicate row using Informatica

Suppose we have Duplicate records in Source System and we want to load only the unique records in the Target System eliminating the duplicate rows. What will be the approach?
Assuming that the source system is a Relational Database, to eliminate duplicate records, we can check the Distinct option of the Source Qualifier of the source table and load the target accordingly.
Source Qualifier Transformation DISTINCT clause

No comments:

Post a Comment