How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / ram mohan reddy
we can do this process by 2 ways ....
1)by dynamic lookup option in lookup(new lookup row) we can
load duplicate rows in one target table and unique rows in
one target table
do to this we need to have router transformation (add to
group ports one is for unique(new lookup row=1) and other is
for duplicate(new lookup row =2))after the lookup trans.
2)we can perform this by aggregator transformation using
coutnt(*) >1 for duplicate rows .here also we need to use
router transformion.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What is an expression transformation?
What is Data Caches size?
Tell me any other tools for scheduling purpose other than workflow manager pmcmd?
how to create user defined function (udf) in informatica
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
Enlist few areas or real-time situations where informatica is required.
Implementation methodology
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
How to start a workflow using pmcmd command?
How to load last n records of file into target table - informatica
Which are the different editions of informatica powercenter that are available?
Can we get 1st record through Informatica(without sequence number).
What are the new features of informatica 9.x developer?
Under what condition selecting sorted input in aggregator may fail the session?
What does “tail –f” command do and what is its use as an Informatica admin.