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

How will you update the first four rows and insert next four rows in a mapping?

5 Answers   CTS,


what is SDLC way of code development?

0 Answers  


What is domain in terms of informatica?

0 Answers  


what is Active lock explain

0 Answers   Satyam,


Difference between task flow and linear task flow

0 Answers  


What is Datadriven?

2 Answers   Informatica,


how do u move the code from development to production?

3 Answers  


I want to run a workflow which consist of 3 sessions. But wat my question is. 1st session should run on DB1if the first session is successful then 2 session should run on db2 and 3rd session should run on DB3 envronments. i want 3 different wf logs. it shoul not override on one log?

1 Answers  


How to generate sequence numbers without using the sequence generator transformation?

0 Answers   Informatica,


how can one eliminate dupliacte data with out using distinct option?

5 Answers   Patni, Wipro,


How can we get two output ports in un-connect transformation?

2 Answers   Ness Technologies,


Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?

3 Answers   Deloitte, TCS,


Categories