How you load distinct records into one target and duplicate
records into another target?
- 3 Answers
- 15433 Views
- Mphasis, I also Faced
- E-Mail Answers
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
How to update source definition?
What happen when you enable grid option avilable at session level ? (Ans found: Scalabily . A single session Parallelization) But how can one session is sharable among different nodes at the same time while running ?
Write the different tools in the workflow manager?
Enlist some properties of sessions.
Explain lookup transformation source types in informatica
How to load data in informatica ?
How to improve the performance of a session using sorter transformation?
can anyone explain me about retail domain project in informatica?
Quickly characterize reusable change?
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What are multi-group transformations?
Performance tuning( what you did in performance tuning)
can u give example for factless fact table
What are the popular informatica products?
What is incremental aggregation?
