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 the different components of powercenter?
What are the tasks that can be performed using sq?
How can informatica be used for an organization?
tell me 5 session failure in real time how can you solve that in your project?
Can we create two repositories on same database instance in oracle?
What is a rank transform?
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.
Clarify the utilization of aggregator cache record?
How to elaborate powercenter integration service?
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
Suppose we do not group by on any ports of the aggregator what will be the output?
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
Different circumstance which drives informatica server to expel records?
What is the difference between STOP and ABORT options in Workflow Monitor?
What is xml source qualifier transformation in informatica?