How to delete duplicate records in a flat file source?
Answer Posted / sushanth1234
Connect the flat file to sorter tx and make ascending and connect from sorter to aggregator
tx make group by port and one o/p port count(port) after use router tx 2 group 1)count<0 and 2)count=0 transfer to target for both group Unique and dublicate.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Quickly characterize reusable change?
How are the sources and targets definitions imported in informatica designer?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
what is the complex transformation you used in informatica
Can informatica load heterogeneous targets from heterogeneous sources?
What is a pre-defined event and user-defined event?
How to load last n records of file into target table - informatica
How do you manage the Parameter files while migrating your data from one environment to another environment?
Under what condition selecting sorted input in aggregator may fail the session?
How can we remove the duplicates from flat file source?
What is meant by pre and post session shell command?
How many types of sessions are there in informatica.please explain them?
How to generate sequence numbers?
What is Session and Batches?
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