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
- 13289 Views
- Puma, I also Faced
- E-Mail Answers
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 |
what is the architecture of any Data warehousing project?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
what are the transformations that are used in data cleansing ? and how data cleansing takes place ?
What is synonym?
What is the format of informatica objects in a repository?
What are the new features of Power Center 5.0?
Briefly define a session task?
What do you mean by blocking transformation?
how to find the 5th highest salary form each department using 1.SQL Query 2. Informatica power center designer?
What does update strategy mean, and what are the different option of it?
what are the fact table & dimensional table in pharmaceutical and hospotal related products???
Can any one explain or sujjest some sites for scd mappings.Thank you
Teradata 
