Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation
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
To import the flat file definition into the designer where should the flat file be placed?
Differentiate between router and filter transformation?
What is the difference between a repository server and a powerhouse?
What are the types of schemas we have in data warehouse and what are the difference between them?
What are mapplets?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
How to extract sap data using informatica? What is abap? What are idocs?
can we override a native sql query within informatica? How do we do it?
tell me the rules and responsblites in our project(my project is development)
What is meant by active and passive transformation?
Name at least 5 different types of transformations used in mapping design and state the use of each.?
where to store informatica rejected data?
Enlist the differences between database and data warehouse.
What is the use of code page?
What is informatica?