Monday, October 1, 2012

How to avoid Duplicate Rows in Informatica

Duplicate Rows in informatica can be avoided by selecting the distinct Check box in the Source Qualifier Transformation.

If  the Source is a Flatfile then it cannot be Prevented by Source Qualifier to give Distinct Data.
For avoiding the duplicate rows we have to use a transformation called Sorter transformation and Select the option called as "Distinct".

One more option to avoid the duplicate rows is by using an aggregator transformation . A groupby in any one of the duplicate column will provide us a result of non duplicate records. 

2 comments:

  1. Its always better to avoid duplicate by using the Source Qualifier tf., If your Source is not a flatfile:)

    ReplyDelete
  2. Really nice.. Thanks..

    ReplyDelete

Please Give Your Comments!!

Note: Only a member of this blog may post a comment.