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

What are the different components of powercenter?

679


What are the tasks that can be performed using sq?

693


How can informatica be used for an organization?

747


tell me 5 session failure in real time how can you solve that in your project?

1736


Can we create two repositories on same database instance in oracle?

701






What is a rank transform?

759


I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1231


Clarify the utilization of aggregator cache record?

657


How to elaborate powercenter integration service?

743


Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar

2403


Suppose we do not group by on any ports of the aggregator what will be the output?

680


Hi, I saw one mapping implemented by my seniors . In Expression transformation they implemented following logic. That is iif(is_date(in_UC_DATINV,'YYYYMMDD'),to_date(in_UC_DATINV,'Y YYYMMDD'),'Inventory Date is either invalid or null') Inventory_Date is validated only for is_date() But not validated for notisnull() . But error says “ either invalid or null “ why? Whether is_date() also check for not isnull() ? or in this logic something is different ? Please answer me . Advance thanks

1503


Different circumstance which drives informatica server to expel records?

634


What is the difference between STOP and ABORT options in Workflow Monitor?

799


What is xml source qualifier transformation in informatica?

825