Hi
If i had source like unique & duplicate records like 1,1,2,3,3,4
then i want load unique records in one target like 2,4 and i want
load duplicate records like 1,1,3,3 then can any body please send
me what is th scnario. my mail i
shek.inform@gmail.com
Answer Posted / sanju_yu
source> dynamic lookup>router,2 conditions in router
1. condition if column_lkp port is null then insert into
target1(unqie)
2. condtion if COLumn_lkp port is not null then insert into
target2(duplicates
Plz let me know if am wrong
Sanjay
Is This Answer Correct ? | 7 Yes | 4 No |
Post New Answer View All Answers
What do you understand by a term domain?
What is union transformation in informatica?
What is InformaticaPowerCenter?
In which transformation you cannot drag ports into it?
can any one explain me what i have to tell about insurance project in interview,,,,when he asked to tell about ur project
What is dynamic cache?
How can we handle two sessions in informatica?
What is fact table? Explain the different kinds of facts.
What are data-driven sessions?
Partition, what happens if the specified key range is shorter and longer
What is the difference between writing a joiner query in ANSI style and THETA style?
What is persistent lookup cache?
What does cheating measurement mean?
Why update strategy and union transformations are active? Explain with examples.
Explain the types of transformations?