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
- 14425 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
In informatica workflow manager, how many repositories can be created?
What is an Integration service in Informatica?
hi real timers . iam waiting for ur reply regarding ETL TESTING
As union transformation gives UNION ALL output, how you will get the UNION output?
What is informatica powercenter repository?
What is complex mapping?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
What is an aggregator transformation?
What is target load order?
Which is the t/r that builts only single cache memory?
Name the different lookup cache(s)?
In informatics server which files are created during the session rums?
What is the use of transformation?
Can we override a native sql query within informatica?
what is the hint? how to use it to reduce the query processing in program?
