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

Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!

2 Answers  


explain one complex mapping with logic? sales project?

0 Answers   Accenture, JPMorgan Chase,


when we create source as oracle and target as flat file, how can i specify first row as column in flat file?

1 Answers  


I have Flat file like the data, sal have 10,000. I want to load the data in the same format as sal as 10,000. Can anybody know the answer means please mail me. Thanks in advance.. My mail id is chandranmca2007@gmail.com

2 Answers   DELL, iGate,


How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?

4 Answers   IBM,






Can i create a lookup table without cache.

7 Answers   iGate,


What is a look up function? What is default transformation for the look up function?

2 Answers   TCS, ASM,


How many ways are there to create ports?

0 Answers   Informatica,


What is the function of look up transformation?

0 Answers  


my sourse is like id name sal--1 aa 1000 ,2 bb 2000, 3 cc 3000 4 dd 4000, 5 ee 6000 , 6 ff 7000 and so on but myrequirement is like this id name sal up_sal,1 aa 1000 null,2 bb 2000 1000, 3 cc 3000 2000 4 dd 4000 3000, 5 ee 5000 4000 , 6 ff 6000 50000 and so on so how can i get it plez reply for this as soon as possible , thanks in advanced

9 Answers  


What is status code?

2 Answers  


I am hvaing SOURCE as 1000,null,null,null null,2000,null,null null,null,3000,null null,null,null,4000 Now i want the OUTPUT as 1000,2000,3000,4000 For more clarification i want to elimate nulls and want in a single line. Please help me out

5 Answers   IBM,






Categories