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
Briefly define a session task?
Why do you use Mapping Parameter and mapping variable?
How do you manage the Parameter files while migrating your data from one environment to another environment?
What is update strategy transform?
What are the static cache and dynamic cache in informatica?
Please let me know how to make encryption and decryption with example?
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
How can we update a record in the target table without using update strategy?
What is domain in terms of informatica?
How can you increase the performance in joiner transformation?
how many types of dimensions are available in informatica?
Explain the features of connected and unconnected lookup.
What is Data Caches size?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance
What is decode in static cache?