Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6 Answers
- 19032 Views
- HCL, Schneider, I also Faced
- E-Mail Answers
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 is a passive transformation?
What does update strategy mean, and what are the different option of it?
How do you migrate data from one environment to another?
Design a mapping to get the pervious row salary for the current row. If there is no pervious row exists for the current row, then the pervious row salary should be displayed as null.
How many ways are there to do 'remove duplicate records in informatica'?
How do you load more than 1 max sal in each department through informatica or write sql query in oracle?
permutations of mapplet
What is a grid in Informatica?
Have you worked with/created Parameter file
TELL ME ONE COMPLEX MAPPING IN UR PROJECT? chandumba2005@gmai.com
what is informatica metadata?
Briefly explain your complete project(sales) flow, (ie. from source received from client, transformations, then despatch to end user) what are all the process. Kindly give step by step process.
what is the -ve test case in your project.
What is a difference between complete, stop and abort?
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
