EDUCBA

EDUCBA

MENUMENU
  • Free Tutorials
  • Free Courses
  • Certification Courses
  • 360+ Courses All in One Bundle
  • Login
Home Data Science Data Science Tutorials Informatica Tutorial Router Transformation in Informatica
Secondary Sidebar
Informatica Tutorial
  • Basisc
    • What is Informatica
    • Careers In Informatica
    • Informatica Architecture
    • All About Informatica Developer Tool
    • Informatica ETL Tools
    • Normalizer Transformation in Informatica
    • Router Transformation in Informatica
    • Transformations in Informatica
    • Transformations in Informatica with Example
    • Rank Transformation in Informatica
    • Joiner Transformation in Informatica
    • Expression Transformation in Informatica
    • Source Qualifier Transformation
    • Lookup in Informatica
    • Mapping in Informatica
    • Informatica MDM
    • Informatica PowerCenter
    • Informatica Cloud
    • Informatica Scenario Based Interview Questions
    • Informatica Cloud Interview Questions
    • Informatica PowerCenter ETL

Related Courses

Informatica Certification Course

Data Visualization Courses

Cloud Computing Certification Course

Router Transformation in Informatica

By Aanchal SinghAanchal Singh

Router Transformation in Informatica

Introduction to Router Transformations in Informatica

Router Transformation in Informatica is a special type of transformation functionality used to route the data flow direction based upon the route transformation condition. The router transformation is mostly used if there are multiple target systems or data tables available to process the logical scenarios in Informatica mappings. It is an active type of transformation in Informatica and is used as a connected transformation. Router Transformation in Informatica supports multiple filter conditions and source data discard functionality to manage data quality to the target systems using the Informatica mapping. One of the use cases of Informatica route transformation is routing the country-specific sales data to different target tables of the oracle database, creating data-marts for analysis.

How to create Router Transformation in Informatica?

Let us have a look at creating a router transformation step by step.

Step 1: Create a source and target in the mapping as below

Router Transformation in Informatica

Start Your Free Data Science Course

Hadoop, Data Science, Statistics & others

Here address data is being stored with many other attributes.

Step 2: Go to the transformation menu and then select the create option.

Transformation menu

Step 3: Once this done, select router transformation. Enter a name for this router transformation and select the create option.

Router Transformation in Informatica

Double click on router transformation to provide conditions for routing conditions. There will be below properties in the transformation tab.

  • The default would be the one that you clicked upon.
  • Rename: This will help the user in renaming the router transformation. This can be any meaningful name that will suggest what it is doing.
  • Make Reusable: If you checkmark this option, then the transformation which is created will become reusable.
  • Description: A description can be provided, which will explain what the transformation is doing.

Router Transformation in Informatica

The next tab which comes in this window is the ‘Ports’ tab. This tab has the below options:

  • Port Name: List of all available columns. By clicking on a new column, you can easily add a new column and similarly, by clicking on the scissors, you can delete a column.
  • I: Columns that are check-marked under this transformation will act as input for the router transformation.
  • O: Columns that are check-marked under this section will act as output columns for the transformation. If any particular column is unchecked, then that column will not be sent to be loaded to the target table.

Router Transformation in Informatica2

The next tab is the group’s tab. Here we can define the group name and conditions which are to be used. In the step ahead, you will observe two groups are created with two filter conditions.

A new group can be created by clicking on the below button.

All in One Data Science Bundle(360+ Courses, 50+ projects)
Python TutorialMachine LearningAWSArtificial Intelligence
TableauR ProgrammingPowerBIDeep Learning
Price
View Courses
360+ Online Courses | 50+ projects | 1500+ Hours | Verifiable Certificates | Lifetime Access
4.7 (86,408 ratings)

Router Transformation in Informatica

Step 4: The router transformation will be created in the mapping. You can drag and drop all columns from source or previous transformations.

Step 5: Once all columns are present in the transformation, then go to its transformation property. You can give a group name and then enter the filter condition for this group.

Router Transformation in Informatica

Here we have two groups. One has filter condition of having OP_TYPE having value as I where values are getting inserted while the other group has filter condition as U where values will be updated.

Step 6: The filter condition can be done by clicking on the filter condition. By clicking on the highlighted arrow, you can open the expression window.

Insert Update Stream

This window will open the below editor and help you in specifying different conditions. The second group can have similar conditions specified similarly. All remaining rows which do not satisfy any of the conditions will act as default output. These will be stored in the default group.

Insert Update Stream

After applying the filter condition, click on OK. Once the filter condition is added you can click on ok then this transformation will be added in the mapping.

Step 7: The ports which are to be routed can be connected to the next transformations or the target.

Insert Update Stream

Once this is done, and all groups are created, you can route the output to the next transformations or the target.

Here the insert group is sent to a target as below:

Insert Update Stream

The update transformation is also traversed to another transformation which is update strategy.

Update Strategy

All remaining ports which do not fulfil the specified conditions are sent to the default group.

Update Strategy

Once the mapping is ready, you should validate it. This is done by going to the Mapping Menu bar and clicking on the validate option.

The validated mapping can be run by creating a workflow. This is done by using the workflow manager. It has two approaches to this.

  • Create workflow manually
  • Create a workflow using the wizard

To create a new workflow, you can go to the workflow menu and then click on the create option. This will open Create Workflow window where a unique name can be mentioned. Once the workflow is created, the next task is of creating a session. A non-reusable task can be created by navigating to the task menu and selecting the create task option. A new mapping window will be opened where you can associate the mapping with the session created. All sources, targets and common properties can be configured in the session task which is created. Once this setup is done, you can go to workflow and click on the start Workflow option. Once this is done, the workflow manager starts the monitor to observe the workflow for any errors or execution status.

Conclusion

The Router Transformation helps in routing the data from one transformation to another. The data can be split according to the different conditions of groups that are created. There is also one default group that will have ports that do not satisfy the group’s conditions. Router transformation acts like the If Else condition or Case condition. The result of the condition will decide where the output should go. It will decide where which data should flow. The rows which do not satisfy the condition can be dropped. The same router transformation can be used in multiple conditions. Router transformation is hence useful in creating different conditions for different input columns.

Recommended Articles

This is a guide to Router Transformation in Informatica. Here we discuss the introduction and steps for Router Transformation in Informatica, respectively. You may also look at the following articles to learn more–

  1. Transformations in Informatica with Example
  2. What is Informatica
  3. Careers In Informatica
  4. All Important Things About Informatica Developer Tool
  5. Informatica ETL Tools
  6. Informatica vs Datastage
  7. What is a Router?
  8. Guide to Lookup in Informatica
Popular Course in this category
Informatica Training (7 Courses)
  7 Online Courses |  47+ Hours |  Verifiable Certificate of Completion |  Lifetime Access
4.5
Price

View Course

Related Courses

Data Visualization Training (15 Courses, 5+ Projects)4.9
Cloud Computing Training (18 Courses, 5+ Projects)4.8
0 Shares
Share
Tweet
Share
Primary Sidebar
Footer
About Us
  • Blog
  • Who is EDUCBA?
  • Sign Up
  • Live Classes
  • Corporate Training
  • Certificate from Top Institutions
  • Contact Us
  • Verifiable Certificate
  • Reviews
  • Terms and Conditions
  • Privacy Policy
  •  
Apps
  • iPhone & iPad
  • Android
Resources
  • Free Courses
  • Database Management
  • Machine Learning
  • All Tutorials
Certification Courses
  • All Courses
  • Data Science Course - All in One Bundle
  • Machine Learning Course
  • Hadoop Certification Training
  • Cloud Computing Training Course
  • R Programming Course
  • AWS Training Course
  • SAS Training Course

ISO 10004:2018 & ISO 9001:2015 Certified

© 2022 - EDUCBA. ALL RIGHTS RESERVED. THE CERTIFICATION NAMES ARE THE TRADEMARKS OF THEIR RESPECTIVE OWNERS.

EDUCBA
Free Data Science Course

SPSS, Data visualization with Python, Matplotlib Library, Seaborn Package

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA Login

Forgot Password?

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA
Free Data Science Course

Hadoop, Data Science, Statistics & others

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

EDUCBA

*Please provide your correct email id. Login details for this Free course will be emailed to you

By signing up, you agree to our Terms of Use and Privacy Policy.

Let’s Get Started

By signing up, you agree to our Terms of Use and Privacy Policy.

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

Loading . . .
Quiz
Question:

Answer:

Quiz Result
Total QuestionsCorrect AnswersWrong AnswersPercentage

Explore 1000+ varieties of Mock tests View more