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 |
Howmany ways yoU can update a relational source defintion and what are they?
what are the Methods For Creating Reusable Transformations?
What is sq transformation?
how you will maintain version?
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Name 4 output files that informatica server creates during session running?
What is an incremental loading? in which situations we will use incremental loading
Can you please mail me a copy of Informatica Certification Exam dumps to sriveniv@hotmail.com
how to run the batch using pmcmd command
What is the Rank index port in Rank transformation?
What is the difference between the system variables $$$SessStartTime and SESSSTARTTIME?
How to elaborate powercenter integration service?