How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / dwhlabs
1> using dynamiclookup concept
2> using variable concept
First solution
source > sorter >dynamic lookup > filter > Target1 and
Target2
for more abt informatica mappings ... www.dwhlabs.in
| Is This Answer Correct ? | 1 Yes | 8 No |
Post New Answer View All Answers
What is the difference between a connected look up and unconnected lookup?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
How can one identify whether mapping is correct or not without connecting session?
What are the informatica performance improvement tips
What is the difference between a repository server and a powerhouse?
explain about unit testing? in real time?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
tell me 5 session failure in real time how can you solve that in your project?
Why update strategy and union transformations are active?
Differentiate between router and filter transformation?
What is the function of look up transformation?
Separate from an archive server and a powerhouse?
differences between service based and product based?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What are the different options available for update strategy?