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?

Read Best Answer

Editorial / Best Answer

sasi.a.kumar  

 Profile Answers by sasi.a.kumar Questions by 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..

RANJAN RASMI DAS

 Profile Answers by RANJAN RASMI DAS Questions by RANJAN RASMI DAS

• Jan 12th, 2011

Router can act both active and passive, one example....Suppose in source we have recordsid.....name -----------10.....aa10.....bb20.....cc20.....dd30.....xx40.....yy We have one target table...

Improve Answer