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
Explain the types of transformations?
What is meant by a domain?
What is the sql query overwrite in source qualifier in informatica
What are the different ways to implement parallel processing in informatica?
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.
Plz can any one say me how to get the informatica certification materials and dumps
What is lookup change?
Explain the types of lookup transformation?
What is meant by target load plan?
How to do unit testing in informatica? How to load data in informatica ?
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?
where to store informatica rejected data?
Difference between Data and Index Caches?
What are the types of caches in lookup? Explain them.
complex mapping ur project u r invlve can u explain and give real time example give me ?