How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / naresh araveti
source> dynamic lookup>router,2 conditions 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)
| Is This Answer Correct ? | 4 Yes | 3 No |
Post New Answer View All Answers
How can you generate reports in informatica?
Explain how many types of dimensions are available in informatica?
Where do we use mapping variables in informatica?
Explain the different kinds of facts.
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
what is the complex transformation you used in informatica
What are junk dimensions?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
Describe data concatenation?
How do you update the records with or without using update strategy?
how to load dimension table and fact table. plz tell me the steps.
Name at least 5 different types of transformations used in mapping design and state the use of each.?
How to load the data from people soft hrm to people soft erm using informatica?
How can we use mapping variables in informatica?
What is the maplet?