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
is it possible to index the data in cache of lkp transformation ?
What is update strategy transform?
What is the difference between a connected look up and unconnected lookup?
Explain in detail about scd type 1 through mapping.
can any one explain about dataflow in the informatica project for bank domain....thanks is advance
What are the various types of transformation?
Explain sessions. Explain how batches are used to combine executions?
What are the different types of repositories created using informatica?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
Enlist the tasks for which source qualifier transformation is used.
How can you validate all mappings in the repository simultaneously?
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
What is meant by active and passive transformation?
What is a code page?
how tokens will generate?