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?
Total Answers and Comments: 11
Last Update: November 13, 2009 Asked by: pawarpossible
If we use only the default group in a router then there is no need to use the router Also that needs to be avoided as unncessary use of any transformation would slow down the ETL process. About why router is termed as passive- Router transformation unlike any other active transformation like normalizer,filter,sorter etc doesn't play with the records(data), rather it just splits the records based on condition we provide in the group.
If we use only the default group in a router then there is no need to use the router Also that needs to be avoided as unncessary use of any transformation would slow down the ETL process. About why router is termed as passive- Router transformation unlike any other active transformation like normalizer filter sorter etc doesn't play with the records(data) rather it just splits the records based on condition we provide in the group.
Router Transformation is not a passive transformation. As the rows get filtered out when it meets a filter condition the transformation is an active transformation.
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.
Router is Active transformation it is used for multiple conditions purpose.
Why it is active transformation means suppose one ROW satisfied two or more conditions that row will comes out more than one same row to the router so the row will come here number of rows.
Passive transformation is that where no. of inputs is equal to no. of outputs and from a router transformations no data will be rejected and you will be getting each and every record which is coming in to it. So Router is passive.
Router is not a passive transformation but it can acts as passive. It uses multiple filter conditions. Filtration is a part of data cleansing. So the transformation which are used for cleansing of data are the active transformation. All the active transformation behaves as passive transformation according to some conditions and incoming data but we cannot call these transformation as passive due to that situations.
In router you are going to route the records based on the condition. Records which has not satisfy the user defined condition will go to the default condition in the router. so ultimately what ever records we are getting as a input will come as output in one way or another.
Router transaction is a Active transaction why it's possible one input value it will give no of group values based on condition. In this case it will satisfy the active type (you can change the noof values either group or conditions wise so it is active in nature).
Who said router is a passive transformation. Go thorugh the powercenter transformation guide once again and check it. Its an Active and Connected transformation. Let me know if you are interested in knowing why?
I think there is fair bit of confusion over whether router is active transformation or passive transformation. The answer to that is router is an ACTIVE transformation. My answer to the question (PASSIVE ROUTER TRANSFORMATION) was based on the context it was asked. Router without any specified groups would have just the default group in it hence would act as passive transformation and solve no actual purpose. It will not play with the number of records and further more it will hit performance also. Inability in conveying the resolution properly is regretted. :-)
1 
3