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
- 10264 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
What is workflow? What are the components of workflow manager?
Performance tuning in UNIX for informatica mappings?
What is status code in informatica?
What is the surrogate key?
How can repository reports be accessed without sql or other transformations?
What is dynamic cache?
What are the various types of transformation?
Explain target update override in informatica
In which transformation you cannot drag ports into it?
what is Active lock explain
Explain the informatica workflow?
How do you load only null records into target? Explain through mapping flow.
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
What is update strategy transform?
State the differences between sql override and lookup override?
