Answered Questions

  • Jul 13 2009
    10:51 AM
    16569
    32

    Passive Router Transformation
    • pawarpossible

    Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?

    Star Read Best Answer

    Editorial / Best Answer

    sasi.a.kumar  

    • Member Since Aug-2009 | Aug 14th, 2009

    Router is an Active Transformation, Most of the time we use router only when we are going to apply multiple conditions on a records, It is absolutely possible for a record to satisfy one or more conditions thus making the router Active, Router is the only active transformation where the number of output records from the transformation is greater or equal to the number of input records given to the transformation.

    bosna

    • Aug 17th, 2011

    AS PER INFORMATICA DOCUMENTATION, Router transformation is ACTIVE and CONNECTED.. Please Don't thumb down if you're not sure..

  • May 03 2009
    10:54 AM
    18027
    28

    Update Strategy
    • saravanan.eswaran

    In which situation do we use update strategy?

    Anil

    • Jun 22nd, 2016

    If we want to perform 2 DML operations but same operations it is not better to use update tr. use property in session (treat source rows as) instead of creating update tr. If we want to perform 2 DML...

    ankit

    • May 4th, 2016

    Can any one tell me in which scenario it is not advisable to use update strategy?

  • Sep 30 2006
    07:24 AM
    8491
    3

    What is SQL override? In which transformation we use override?
    • sravanmca2k5

    Vamsi Krishna.K

    • Oct 1st, 2006

    Hello,By default informatica server will generate sql query for every action, if that query is not able to perform the exact task, we can modify that query or we can genrate new once with new conditions and with new constraints.1. source qualifier2. lookup3. target