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
Design a mapping to load a target table with the following values from the above source?
Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance
Under what condition selecting sorted input in aggregator may fail the session?
Describe the impact of several join conditions and join order in a joiner transformation?
How can we delete duplicate rows from flat files?
What are the conditions needed to improve the performance of informatica aggregator transformation?
How you know when to use a static cache and dynamic cache in lookup transformation?
What is xml source qualifier transformation in informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
What are the differences between joiner transformation and source qualifier transformation?
What is meant by pre and post session shell command?
I am new to informatica and learning it,can anybody please tell me how we receive source as flat file in informatica,from where we get this flat file?
SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N
What is parallel processing in informatica?
What are some examples of informatica etl programs?