Informatica Data Warehousing Question:
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
| Previous Question | Next 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? |