How to send duplicates to one target and unique rows to one
target?target is empty
Answer Posted / venkat
S->S.Q->Aggr->Rtr->T1
->T2
Where Aggr take group by option
Rtr group1 condition reccount>1..........>T1
Rtr default group to....................>T2
T1 records are unic records
T2 records are duplicate records
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Enlist the advantages of informatica.
Differentiate between source qualifier and filter transformation?
Explian the Process of deployment groups in informatica
How to update source definition?
Design a mapping to load a target table with the following values from the above source?
which one is better performance wise joiner or look up
What are the limitations of joiner transformation?
Explain the difference between mapping parameter and mapping variable?
Define mapplet?
define galaxy repository in informatica
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
is it possible to index the data in cache of lkp transformation ?
What are mapplets?
Explain sessions?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?