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)

Answers were Sorted based on User's Feedback



how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / 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

how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / harish konda

We know that Dynamic Look Up Cache returns 1 for insert and
2 for update. So connect the source to the lookup which is
Dynamic and in next in router create 2 conditions. Records
which new it will return 1 and records which are there it
returns 2.

Is This Answer Correct ?    4 Yes 3 No

how to send unique records to one target and duplicate records to another target by using dynamic l..

Answer / dave

May be i understood question wrong , but :
For unique records you can use in Source Qualifier SQL with
having count condition = 1 to cut the unique records to one
target
And for second target same query but with >1 condition
---

Is This Answer Correct ?    2 Yes 9 No

Post New Answer

More Informatica Interview Questions

what are the row and column separations in Flat Files

3 Answers   CTS,


What is persistent lookup cache?

0 Answers  


Where is the cache stored in informatica?

5 Answers   Infosys, Satyam,


How do you handle two sessions in Informatica

0 Answers   Informatica,


Target increases every day even though no new record was inserted

0 Answers   Accenture,


I am having a table with columns ID NAME 1 x and the requirement is to get the o/p like this 1 y ID Count(*) 1 z 1 3 2 a 2 2 2 b 3 c so write a sql query to get the id n how many times its count of repetition n there u shouldn't get the distinct(i.e id-3) Reply as early as possible

3 Answers   IBM,


How do you load alternate records into different tables through mapping flow?

0 Answers  


What is confirmed fact in dataware housing?

2 Answers   Hewitt, TCS,


What are the features of complex mapping?

0 Answers  


in which situations do u go for sequence generator ?

2 Answers   TCS,


I have source data like this col1 col2 col3 5 3 8 6 2 9 7 1 10 and i want to get target as col1 col2 col3 5 1 8 6 2 9 7 3 10 which transformation i have to use and how?

3 Answers  


can we use mapplet as starting n ending object in mapping

2 Answers   TCS,


Categories