• Home
  • sasi.a.kumar Answers

Answered Questions

  • Jul 13 2009
    10:51 AM
    15821
    48

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

  • Sep 21 2004
    04:00 AM
    2728
    8

    What r the active and passive transforamtions?

    An active transforamtion can change the number of rows that pass through it.A passive transformation does not change the number of rows that pass through it.

    avneeshrathor

    • Nov 3rd, 2009

    Thats not correct. By this definition Update Strategy should be a passive transformation but it is not.So correct answer is that any transformation which can change 1. Number of rows 2. Row type i.e. DD_INSERT, DD_DELETE... 3. Transaction control... All these are active ones.