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
What are some examples of informatica etl programs?
How can we handle two sessions in informatica?
What does command task mean?
Differentiate between reusable transformation and mapplet.
Which files are created during the session rums by informatics server?
what is Active lock explain
How do you load alternate records into different tables through mapping flow?
Explain what are the different types of transformation available in informatica. And what are the mostly used ones among them?
lookup transformation with screenshots
Explain the code page compatibility?
What is a filter transformation and why it is an active one?
How to update source definition?
Quickly characterize reusable change?
What is the Rank index port in Rank transformation?
Which are the different editions of informatica powercenter that are available?