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
Explain what are the different types of transformation available in informatica.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
Is stop and abort are same in informatica?
How to do unit testing in informatica? How to load data in informatica ?
What is session task and command task?
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
Explain the different dimensions.
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
what kind of issue you will get in environment? (we ll call help desk to raise ticket rite?
What do you mean by enterprise data warehousing?
Why is sorter an active transformation?
What differs when we choose the sorted input for aggregator transformation?
Partition, what happens if the specified key range is shorter and longer
permutations of mapplet