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 |
Issue with Update override at Target table in Informatica.
how to join two flat files in informatica?
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?
How can a transformation be made reusable?
What is informatica metadata and where is it stored?
How can you recognise whether or not the newly added rows in the source r gets insert in the target ?
In which scenario did you used pushdown optimization?
what is SDLC way of code development?
How to display First letter of Names in Caps?
can we use mapplet as starting n ending object in mapping
What do you understand by a term domain?
What is standalone command task?