Interested to Buy Any Domain ? << Click Here >> for more details...
How to send duplicates to one target and unique rows to one
target?target is empty
- 9 Answers
- 30619 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
What is rank index in rank transformation?
What are the types of lookup transformation?
in reporting we add some new objects,how we get the count of the newly added objects to the report
Under what condition selecting sorted input in aggregator may fail the session?
How many ways are there to create ports?
what is mean by complex business rule ?
What are the restrictions of union transformation?
What are the new features of Power Center 5.0?
Can we create a node as a gateway node and the same node can be assigned to a grid?
What is the function of union transformation?
What is a shortcut and copy in Informatica and how two are different with each other?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What are the designer tools for creating transformations?
Target increases every day even though no new record was inserted
EXL informatica Questions
