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 are Dimensional table?
How to extract sap data using informatica? What is abap? What are idocs?
what is granularity,what type of granularity we will take in fact tables either lowlevel or highlevel,if two tables having same granularity that is posiable or not
What is a difference between complete, stop and abort?
How we can create indexes after completing the loan process?
How to start a workflow using pmcmd command?
What are the components of workflow manager?
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?
What is the surrogate key?
-Which expression we can not use in Maplets?, -Can we join(relate) two dimensions in a schema? -Why and where we use 'sorted input' option?
Explain the types of lookup transformation?
How does the aggregator transformation handle null values?
Define pmcmd command?
What are the new features of Power Center 5.0?
Explain the scenario which compels informatica server to reject files?