How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 28106 Views
- Amazon, IBM, Wipro, I also Faced
- E-Mail Answers
Answer Posted / shiva
s-->sq-->agg-->rtr-->tgt1
'--> tgt2
in aggr take two ports count(*)=1
count(*)>1 take group by on column
send this to rtr(create 2 groups in rtr)
| Is This Answer Correct ? | 5 Yes | 2 No |
Post New Answer View All Answers
How to create a non-reusable instance of reusable transformations?
Enlist the advantages of informatica.
Performance tuning in UNIX for informatica mappings?
What do think which one is the better joiner or look up?
What is the status code in stored procedure transformation?
What is workflow? What are the components of workflow manager?
What is sq transformation?
What is flashback table ? Advance thanks
How do we call shell scripts from informatica?
What is a pre-defined event and user-defined event?
How does a rank transform differ from aggregator transform functions max and min?
What are the differences between oltp and olap?
Explain lookup transformation is active in informatica
What is informatica powercenter repository?
What is the function of look up transformation?
