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

Explain the types of transformations?

800


What is meant by a domain?

851


What is the sql query overwrite in source qualifier in informatica

832


What are the different ways to implement parallel processing in informatica?

1107


source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.

2533


Plz can any one say me how to get the informatica certification materials and dumps

1810


What is lookup change?

820


Explain the types of lookup transformation?

779


What is meant by target load plan?

744


How to do unit testing in informatica? How to load data in informatica ?

887


How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?

1912


where to store informatica rejected data?

850


Difference between Data and Index Caches?

871


What are the types of caches in lookup? Explain them.

753


complex mapping ur project u r invlve can u explain and give real time example give me ?

2070