Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation



Why can't we connect 2 active transformations to an active transformation ? Ex:- One aggria..

Answer / 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

More Informatica Interview Questions

8.what is mapplet ?give example?

2 Answers  


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!!

2 Answers  


How mapping parameter and variable works

1 Answers  


By using Filter Transformation,How to pass rows that does not satisfy the condition(discarded rows) to another target?

14 Answers   CSC, Emphasis,


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

21 Answers   Deloitte,






what is incremental data aggregation?

3 Answers   IBM,


what r the propertes of workflow? and write quary to select dept more ten employess in dept.?

2 Answers  


What is workflow variable? When we use workflow variable? Can any one explain me with one example???

2 Answers   TCS,


In update strategy t/r we had given dd_insert condition & in session we gave delete condition . Then what will happen? mapping will run ?

3 Answers   emc2,


difference between top down(w.h inmon)and bottom up(ralph kimball)approach?

2 Answers   PayPal,


what is the size ur source like(file system or database)? how many record daily come u r banking project?

0 Answers   Cognizant, Flextronics,


What is repository manager?

0 Answers  






Categories