Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records in a flat file source?
- 2 Answers
- 8686 Views
- I also Faced
- E-Mail Answers
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
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
What is domain in terms of informatica?
What does command task mean?
What is dimensional table? Explain the different dimensions.
How can you differentiate between powercenter and power map?
What do you mean by blocking transformation?
Explain what is informatica metadata and where is it stored?
What is the difference between stop and abort in informatica
which one is better performance wise joiner or look up
Explain the scenario which compels informatica server to reject files?
How many number of sessions can one group in batches?
What are the transformations that are not supported in mapplet?
What are the types of caches in lookup?
What is union transformation?
What are the advantages of informatica?
