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
What is the difference between a repository server and a powerhouse?
What do you mean by blocking transformation?
What are the new features of informatica 9.x developer?
What are the transformations that are not supported in mapplet?
Explain pushdown optimization and types in informatica
Explain sessions. Explain how batches are used to combine executions?
How to improve the performance of a session using sorter transformation?
Explain transaction control transformation in informatica
Explain the shared cache and re-cache?
What is main use of mapplet?
Explain Dataware house architecture .how data flow from intial to end?
How can one identify whether mapping is correct or not without connecting session?
How to create the list file having millions of flat files while indirect loading in informatica? In indirect file loading, suppose we have less no.of flat files then we can enter files names manually in list file creation. If millions of files are there, how can we enter the flat file names in list file?
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???