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


Please Help Members By Posting Answers For Below Questions

Explain the different kinds of facts.

698


what is the end to end process meaning in my project(my project is development)and functionality plz tell me

1652


Informatica settings are available in which file?

726


Under what conditions selecting sorted input in aggregator will still not boost session performance?

777


What is a snowflake schema?

706






can u any challenge your project?

1749


How to convert multiple rows to single row (multiple columns) in informatica

1081


Explain the code page compatibility?

789


What are the different components of powercenter?

747


Can you use flat files in Mapplets.

2365


What is workflow? What are the components of the workflow manager?

815


what is SDLC way of code development?

1712


How to use procedural logic inside infromatica?

799


Mention some types of transformation?

750


What do you mean by enterprise data warehousing?

791