How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
Answer Posted / keyrun
Hi, There are many ways to delete the duplicates!
By Using the following Transformations you can delete the Duplicates:
Source Qualifier: Use SQ and check 'Distinct' property (If the Source is Relational)
Sorter: Use sorter and in Properties tab Check 'Distinct'(If the Source is Flat File)
Aggregator: Use Aggregator & Group by on the key port.
Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
How do you use reject loader.
what is INFORMATICA TESTING process
What all are steps in up gradation of Informatica server?
What is pmcmd command?
In how many ways we can create ports?
What are mapplets? How is it different from a Reusable Transformation?
Can we override a native sql query within informatica?
Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
server hot-ws270 is connect to Repository B. What does it mean?
permutations of mapplet
What is an active transformation?
can anyone suggest best free Talend data integration training online
Can anyone tell me the new features in Informatica 9 Version?
How union transformation is used?
What is workflow? What are the components of workflow manager?