how to send unique records to one target and duplicate
records to another target by using dynamic lookup cache?????
please explain me briefly///(when we use this we look up on
which target unique target ya duplicate target)
Answer Posted / sarvesh
whenever we create dynamic lookup a default col gets added i.e. newlokuprow it has a defaul value 1 for insert that is newrow and 0 for delete or duplicate or same row which already exists. so just use router tr and separate the 0 value row will eliminate the duplicates.
Is This Answer Correct ? | 9 Yes | 6 No |
Post New Answer View All Answers
What is meant by query override?
what are all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
my source is junk data how will u remove that junk data by using unix please any one replay me
without table how to come first record only in oracle?
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
can any one give some examples for pre sql and post sql(Except dropping and creating index).
How to join three sources using joiner?
How to create a non-reusable instance of reusable transformations?
Explain scd type 3 through mapping.
What is intricate mapping?
What is event and what are the tasks related to it?
What is confirmed fact in dataware housing?
In what scenario we use to improve session performance by pushdown optimization?can any one give example?
define galaxy repository in informatica
What is joiner change?