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
- 21975 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 are the components of the workflow manager?
what is the -ve test case in your project.
waht type of interface is used for testing the data in informatica
can anyone explain me about retail domain project in informatica?
What is mapplet in informatica?
have u done any performance tuning? how u ll do?
Where can we find the throughput option in informatica?
Mention a few design and development best practices for informatica?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What is domain and gateway node?
What do you mean incremental aggregation?
How will the document be delivered to me?
What is aggregate cache in aggregator transformation?
What is the difference between source qualifier transformations source filter to filter transformation?
Explain the types of lookup transformation?
