Interested to Buy Any Domain ? << Click Here >> for more details...
Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation
- 1 Answers
- 14532 Views
- Puma, I also Faced
- E-Mail Answers
Answer Posted / sudheer113
The Designer does not allow you to connect multiple active transformations or an active and a passive transformation to the same downstream transformation or transformation input group because the Integration Service may not be able to concatenate the rows passed by active transformations. For example, one branch in amapping contains an Update Strategy transformation that flags a row for delete. Another branch contains an Update Strategy transformation that flags a row for insert. If you connect these transformations to a single transformation input group, the Integration Service cannot combine the delete and insert operations for the row.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
Implementation methodology
What is an expression transformation?
What is the need of an ETL tool?
What is informatica? Why do we need it?
What is intricate mapping?
What is an unconnected transformation?
Please let me know how to make encryption and decryption with example?
What do you understand by term role-playing dimension?
How to Create a folder using pmrep command?
What is a dimensional model?
How identifying bottlenecks in various components of informatica and resolving them?
can we override a native sql query within informatica? How do we do it?
What is a stored procedure transformation?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
What are the different versions of informatica?
