How to eliminate duplicate records in informatica mapping?
Explain with an example....
Answer Posted / 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 |
Post New Answer View All Answers
Define Pmrep command?
How many ways a relational source definition can be updated and what are they?
Which development components of informatica have the highest usage?
How you know when to use a static cache and dynamic cache in lookup transformation?
What if the source is a flat-file?
can you please explain me pre session and post session options?
What is rank transformation in informatica
What is aggregate cache in aggregator transformation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What are the popular informatica products?
4 yrs etl devloper roles and responsibilities?any body give solutions
What is a predefined event?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
How do you take back up of repository?