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
Explain the different kinds of facts.
what is the end to end process meaning in my project(my project is development)and functionality plz tell me
Informatica settings are available in which file?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What is a snowflake schema?
can u any challenge your project?
How to convert multiple rows to single row (multiple columns) in informatica
Explain the code page compatibility?
What are the different components of powercenter?
Can you use flat files in Mapplets.
What is workflow? What are the components of the workflow manager?
what is SDLC way of code development?
How to use procedural logic inside infromatica?
Mention some types of transformation?
What do you mean by enterprise data warehousing?