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
- 13323 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 grain level in DWH? If i have year to day. what is the grain level of DWH from year to day.
How/where can i install Informatica software with oracle or teradata as database
Enlist few areas or real-time situations where informatica is required.
What will happen if we have a filter transformation used in a mapping and in the filter condition we specify 1. Yes nothing else, only the number 1. In other words, assuming we have 10 rows coming to this filter transformation as an input, how many rows will be output by this transformation when we have only 1 in the filter condition?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
what is the function of 'F10' informatica ?
Whats the difference between $, $$, $$$
What is difference between partioning of relatonal target and partitioning of file targets?
Hi 2 every one. i dont have real time experience, and please suggest me for following questions. a) we get the source data from what type of source systems? b) In banking domain project what are the FACT & DIMENTION tables please list out them? c) please write some colomn names in a table? Please reply for aboue questions?..... Thanks in advance.
how to connect two or more table with single source qualifier?
IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?
What is the format of informatica objects in a repository?
Teradata 
