Why can't we connect 2 active transformations to an active
transformation ?
Ex:- One aggriagator and one sq trans to an router
transformation
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 |
in oracle write query yourname+1 from dual
what is index?how it can work in informatica
What is joiner cache?
How many number of sessions can one group in batches?
How can we send the flat file data to different targets(which are also flat files) based on the name of flat file with out adding extra columns?
what is the process we used in joiner transformation,there is no matching column in sources?
How is Source Side push down optimization different to just providing a SQL override in Source qualifier transformation.
why we use source qualifier transformation?
when we create source as oracle and target as flat file, how can i specify first row as column in flat file?
What is the reusable transformation?
What are parallel querys and query hints?
How to identify this row for insert and this row for update in dynamic lookup cache