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 to join three sources using joiner?

0 Answers  


I have 4 columns in a table say, name ,address, salary and city. So based on distinct city names, i need to combine the other data and send it to a flat file. Distinct city names can be 4 or 5 or 6. So it has to dynamically generate flat files(4 or 5 or 6) corresponding to the city names.

2 Answers  


how DTM buffer size and buffer block size are related

3 Answers   Wipro,


Can we use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?

0 Answers  


What is the difference between normal and bulk loading? Which one is recommended?

1 Answers  






Diff B/W MAP Parameter, SESSION Paramater, DataBase connection session parameters.? Its possible to Create 3parameters at a time? If Possible which one will fire FIRST?

6 Answers   HCL, Accenture,


Why do flat file load is faster if you compare that with table load ? Please answer me. Advance Thanks, Manojkumar

11 Answers   IBM,


what is hash table in informatica?

1 Answers   Zensar,


What is the difference b/w natural key and surrogate key

1 Answers  


What are the different types of schemas?

11 Answers   ITC Infotech,


sample mappings for scd1,scd2 and scd3

2 Answers   Cognizant,


difference between stop and abort

2 Answers  






Categories