How to eliminate duplicate records in informatica mapping?
Explain with an example....
Answer / venkatesh
by using aggrigator transformation we can eliminate
duplicate records in informatica
The flow will be like this
source--->aggrigator----->target
in aggrigator group by all ports then the out put is only
unique records
connect it to the target
2)we can do it by sorter also in sorter if we enable select
distinct then it will gives unique row
3)if u r source is database then u can select distinct in
sourcequalifier it self
Is This Answer Correct ? | 23 Yes | 0 No |
What is aggregate cache in aggregator transforamtion?
how can u tune u r informatica mapppings
how eliminate the duplicates in flat file with out using sorter ,aggregater
What is the difference between a shortcut of an object and copy of an object? Compare them.
explain about session partitions ?
How to load the source table into flat file target(with columns) in informatica?
How can you differentiate between powercenter and power map?
Write the different tools in the workflow manager?
How do you remove duplicate records in informatica? And how many ways are there to do it?
Why use shortcuts(Instead of making copies).
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
i have source flat file like 1 a,1 b,1 c,2 a,2 b,2 c i want output as 1 a,b,c and 2 a,b,c ... how can achieve this