Interested to Buy Any Domain ? << Click Here >> for more details...
How do we eliminate duplicate records in a flat file without using Sorter and Aggregator?
- 7 Answers
- 21762 Views
- iNautix, I also Faced
- E-Mail Answers
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 primary and backup node?
Explain incremental aggregation in informatica
What are data-driven sessions?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Performance tuning( what you did in performance tuning)
What is meant by lookup transformation? Explain the types of lookup transformation?
Name the different lookup cache(s)?
Where do we use mapping variables in informatica?
How big was your fact table
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
What are the various types of transformation?
Is there any way to read the ms excel datas directly into informatica?
Explain your project of banking domian.
What are the types of data warehouses?
Explain pmcmd command usage in informatica
