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
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|
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
|Is This Answer Correct ?||4 Yes||3 No|
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
And for second target same query but with >1 condition
|Is This Answer Correct ?||2 Yes||9 No|
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!!
explain one complex mapping with logic? sales project?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
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 email@example.com
How do you avoid duplicate records with out using source qualifier,expression,aggrigator,sorter and lookup transformations ?
Can i create a lookup table without cache.
What is a look up function? What is default transformation for the look up function?
How many ways are there to create ports?
What is the function of look up transformation?
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
What is status code?
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