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

karttik

 Profile Answers by karttik Questions by karttik

• Oct 23rd, 2009

Functionally we can say day to day business activities is a transaction. Transaction is a unit of work. Technically we can say Physical change in database after submitting a commit or rollback statement.

irfan

• Sep 8th, 2006

Hi,      Transaction is any event that indicates some action.      In DB terms any commited changes occured in the database is said to be transaction.

Answer Question  Select Best Answer