How to delete duplicate records if we have huge volume of
records in a table ?
(rowid is not the correct approach)
Answer Posted / chandrasekar
First we can count the no of records using aggregator
Transformation with group by (port) for ex, in emp table
take empno. Second we can take the Filter condition like
count=1. Other records are rejected not loaded into the target.
Hope it will help little bit...
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
State the limitations where we cannot use joiner in the mapping pipeline?
server hot-ws270 is connect to Repository B. What does it mean?
Performance tuning( what you did in performance tuning)
If informatica has its scheduler why using third party scheduler?
What is the format of informatica objects in a repository?
Enlist few areas or real-time situations where informatica is required.
What is the benefit of session partitioning?
What is the difference between router and filter?
can we override a native sql query within informatica? Where do we do it? How do we do it?
Differentiate between sessions and batches?
Explain informatica architecture - version 8 / 9
What are the different versions of informatica?
How to implement security measures using repository manager?
What is the session task and command task?
What are the different clients of powercenter?