Informatica Data Warehousing Question:
Download Questions PDF

How to eliminate duplicate rows from flat file?

Answer:

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

Download Informatica Data Warehousing Interview Questions And Answers PDF

Previous QuestionNext Question
How to load the data from people soft hrm to people soft erm using informatica?Explain How to export mappings to the production environment?