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


Please Help Members By Posting Answers For Below Questions

Briefly define a session task?

595


Why do you use Mapping Parameter and mapping variable?

1292


How do you manage the Parameter files while migrating your data from one environment to another environment?

555


What is update strategy transform?

580


What are the static cache and dynamic cache in informatica?

722






Please let me know how to make encryption and decryption with example?

1475


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

1652


How can we update a record in the target table without using update strategy?

663


What is domain in terms of informatica?

567


How can you increase the performance in joiner transformation?

715


how many types of dimensions are available in informatica?

565


Explain the features of connected and unconnected lookup.

549


What is Data Caches size?

659


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

1599


What is decode in static cache?

598