How to eliminate duplicate records in informatica mapping?
Explain with an example....



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

Post New Answer

More Informatica Interview Questions

Issue with Update override at Target table in Informatica.

2 Answers  


how to join two flat files in informatica?

3 Answers   Wipro,


when i was running the seesion, after loading 100 records, session suddenly fails.Next time i want to load the remaing rows in target with out truncate target table.What should i use?

7 Answers   Cegedim, IBM, TCS,


How can a transformation be made reusable?

0 Answers   Informatica,


What is informatica metadata and where is it stored?

0 Answers  


How can you recognise whether or not the newly added rows in the source r gets insert in the target ?

2 Answers  


In which scenario did you used pushdown optimization?

1 Answers  


what is SDLC way of code development?

0 Answers  


How to display First letter of Names in Caps?

7 Answers  


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


What do you understand by a term domain?

0 Answers  


What is standalone command task?

0 Answers  


Categories