Router
transformation is an active transformation that routes data into multiple
output groups based on one or more conditions. If you need to test the same
input data based on multiple conditions, use a Router transformation in a
mapping instead of creating multiple Filter transformations to perform the same
task. The Router transformation is more efficient.
Groups in Router Transformation
Input Group
The input group
includes all input ports that you add to the transformation.
Output Groups
1. User-Defined Groups
A
user-defined group consists of output ports and a group filter condition. You
can create and edit user-defined groups on the Groups tab with the Developer
tool. The Data Integration Service uses the condition to evaluate each row of
incoming data. If a row meets more than
one group filter condition, the Data Integration Service passes this row
multiple times.
2. The Default Group
The
Developer tool creates the default group after you create one user-defined
group. The Developer tool does not allow you to edit or delete the default
group. This group does not have a group filter condition associated with it. If
all of the group conditions evaluate to FALSE, the Data Integration Service
passes the row to the default group. If you want the Data Integration Service
to drop all rows in the default group, do not connect it to a transformation or
a target in a mapping.
Advanced Properties for Router Transformation
Tracing Level Amount of detail that appears in
the log for this transformation.
Scenario
Employees in
different departments to different tables.
*In case of any questions, feel free to leave comments on this page and I would get back as soon as I can.
Pretty great post. I just stumbled upon your blog.
ReplyDeletehttp://www.tekclasses.com/
Excellent piece of information,if interested visit
ReplyDeletehttp://www.tekclasses.com/
Hi
ReplyDeleteIs it possible to determine the order in which Groups are evaluated and hence subsequently processed within a Router?
I have a Mapping with 2 legs - I need it to potentially go down leg 1 before it executes leg 2 but I can't get this to occur - even though Group 1 is the first Group in the Router.
What determines the evaluation / execution order of Groups? All I can find is this;
"The Integration Service determines the order of evaluation for each condition based on the order of the connected output groups."
But what does this actually mean?
Any assistance would be greatly appreciated,
Thanks,
Liam.
The information provided here is well defined and informative... Thank you for sharing this information with us.. If anyone wants to learn Informatica power center just visit our website..
ReplyDeletetekclasses.in
The information provided here is well defined and informative... Thank you for sharing this information with us.. If anyone wants to learn Informatica power center just visit our website..
ReplyDeletetekclasses.in
I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Informatica Powercenter 9.X Developer training, kindly contact us http://www.maxmunus.com/contact
ReplyDeleteMaxMunus Offer World Class Virtual Instructor led training on Informatica Powercenter 9.X Developer training. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us.
Nitesh Kumar
MaxMunus
E-mail: nitesh@maxmunus.com
Skype id: nitesh_maxmunus
Ph:(+91) 8553912023
http://www.maxmunus.com/