How you load distinct records into one target and duplicate
records into another target?
Answer Posted / moorthy. g
S-SQ-Exp-Rtr-Tgt1/Tgt2
Exp:
flag: decode(true, col1=prev_col1,'Y','N')
pre_col1=col1;
Rtr:
Group1 --- flag='Y' --- Tgt1 -- Duplicate Values
Group2 --- flag='N' --- Tgt2 -- Unique Values
Best Regards,
Manthiramoorthy. G
Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Explain the pipeline partition with real time example?
What is native users?
Is stop and abort are same in informatica?
What is the Rank index port in Rank transformation?
On which transformations you created partitions in your project?
what is the complex transformation you used in informatica
What is an expression transformation in informatica?
Make a note of the quantity vaults made in informatica?
What are the advantages of informatica?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are the reusable transformations?
As union transformation gives UNION ALL output, how you will get the UNION output?
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
is it possible to index the data in cache of lkp transformation ?
what is the Default Source Option For Update Strategy Transformation?