Informatica Data Warehousing Interview Question:

How to eliminate duplicate rows from flat file?

Submitted by: Administrator

Use Sorter Transformation. When you configure the Sorter Transformation to treat output rows as distinct, it configures all ports as part of the sort key. It therefore discards duplicate rows compared during the sort operation
Submitted by: Administrator