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
- 10041 Views
- Puma, I also Faced
- E-Mail Answers
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
Why do you use Mapping Parameter and mapping variable?
Explain the shared cache and re-cache?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
How to improve the performance of a session using sorter transformation?
How do you load unique records into one target table and duplicate records into a different target table?
Explain what are the different types of transformation available in informatica.
What is a joiner transformation and why it is an active one?
Explian the Process of deployment groups in informatica
What is the scenario which compels informatica server to reject files?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
Define pmcmd command?
Mention few advantages of router transformation over filter transformation.
what is Active lock explain
Explain pushdown optimization $pushdownconfig parameter - informatica
How identifying bottlenecks in various components of informatica and resolving them?
