Why can't we connect 2 active transformations to an active
Ex:- One aggriagator and one sq trans to an router
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|
8.what is mapplet ?give example?
Can anyone know that what is the Source File limitation in Informatica? To be more precise .. how many flat file we can use as a source in a mapping if.. 1) The Structure of flat files are same & 2) If the Structure of flat files are different. Please explain the procedure also if it dosn't bother one much!!
How mapping parameter and variable works
By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?
from Source 100 rows are coming, on target there are 5 m rows which options is better to match data 1. Joiner 2 No cache 3. Static 4. Dynamic
what is incremental data aggregation?
what r the propertes of workflow? and write quary to select dept more ten employess in dept.?
What is workflow variable? When we use workflow variable? Can any one explain me with one example???
In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?
difference between top down(w.h inmon)and bottom up(ralph kimball)approach?
what is the size ur source like(file system or database)? how many record daily come u r banking project?
What is repository manager?