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


Please Help Members By Posting Answers For Below Questions

How do you use reject loader.

2344


what is INFORMATICA TESTING process

2070


What all are steps in up gradation of Informatica server?

826


What is pmcmd command?

901


In how many ways we can create ports?

912


What are mapplets? How is it different from a Reusable Transformation?

872


Can we override a native sql query within informatica?

838


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

826


server hot-ws270 is connect to Repository B. What does it mean?

2170


permutations of mapplet

2275


What is an active transformation?

859


can anyone suggest best free Talend data integration training online

1498


Can anyone tell me the new features in Informatica 9 Version?

1802


How union transformation is used?

801


What is workflow? What are the components of workflow manager?

939