Interested to Buy Any Domain ? << Click Here >> for more details...
How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
- 6 Answers
- 10042 Views
- Puma, I also Faced
- E-Mail Answers
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
Enlist the tasks for which source qualifier transformation is used.
How identifying bottlenecks in various components of informatica and resolving them?
Enlist the advantages of informatica.
How to update a particular record in target with out running whole workflow?
What is a predefined event?
What is a standalone command task?
Explain the features of connected and unconnected lookup.
Explain sessions. Explain how batches are used to combine executions?
Informatica Server and Client are in different machines. You run a session from the server manager by specifying the source and target databases. It displays an error. You are confident that everything is correct. Then why it is displaying the error?
Sequence generator, when you move from develoment to production how will you reset
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
Calculate sum of salaries department wise. Then the sum will be repeat for all columns in each department. Develop a mapping for this.
What is informatica metadata and where is it stored?
What is olap (on-line analytical processing?
What is Cognos script editor?
