How can we eliminate duplicate rows from flatfile,explain?
Answer Posted / veera reddy
By Using Aggregator transformation by selcting the group by
option or using sorter by using distinct option or by using
dynamic lookup by selecting distinct option.
| Is This Answer Correct ? | 6 Yes | 5 No |
Post New Answer View All Answers
What is the use of an aggregator cache file?
Why is sorter an active transformation?
Explain how to import oracle sequence into informatica?
What is the difference between router and filter?
Performance tuning( what you did in performance tuning)
what is the complex transformation you used in informatica
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What is the function of union transformation?
What are the designer tools for creating transformations?
What is native users?
What are the advantages of informatica?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
in u flatfile some of fact records are missed then u load the diminision records are not if u load diminsion records what about fact table records
How an expression transformation differs from aggregator transformation?
What is the Rank index port in Rank transformation?