How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Answer Posted / kiran
We can use dynamic cache in lookup to eliminate duplicates.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
What is session task and command task?
What are the different clients of powercenter?
Can any one give me a real time example for FACT TABLE & DIMENSIONAL TABLE?
how we can load rejected record's at run time?(not through bad files)
How would you copy the content of one repository to another repository?
How to start a workflow using pmcmd command?
How many ways are there to do 'remove duplicate records in informatica'?
I have 10 columns in a flat file and 10 rows corresponding to that columns. I want column number 5 and 6 for last five records. In unix as well as informtica.
How does a sorter cache works?
What happens when a session fails and you click on recover?
Write the unconnected lookup syntax?
What is parallel processing in informatica?
What's the layout of parameter file (what does a parameter file contain?)?
What is a code page?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N