How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
Answer Posted / harish konda
Give the SQL query to sort the data in source in source
qualifier t/f.
And then connect to exp t/f and add one more port (say flag)
to generete numbers like, when prev row and current row
values are same, then increment number, or else give 1.
And next connect to Filter t/f and give the condition in
filter as flag=1.
Then rout the data to target.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is informatica worklet?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance
What are the guidelines to be followed while using union transformation?
How does a sorter cache works?
How many numbers of sessions can one group in batches?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What is aggregator transformation in informatica?
What is option by which we can run all the sessions in a batch simultaneously?
What is the scenario which compels informatica server to reject files?
Hi all, Can you please send me the Dimensions and fact tables which are used in mutual fund project. and please send me the brief summary about the project. Please do the needful.
How do you promote a non-reusable transformation to reusable transformation?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
explain one complex mapping with logic? sales project?
What is a router transformation?
where to store informatica rejected data?