Router Transformation in Informatica - Shikshaglobe

Content Creator: Vijay Kumar

What is Router Transformation?

Switch change is a functioning and associated change which is like channel change used to channel the source information.

The extra usefulness given adjacent to separating is that the disposed of information (sifted through information) can likewise be gathered in the planning, as well as the different channel conditions can be applied to get numerous arrangements of information.

For instance, while separating the information structure deptno =10, we can likewise get those records where deptno isn't equivalent to 10. In this way, switch change gives numerous result gatherings, and each result gathering can have its own channel condition.

Likewise, there is likewise a default bunch, this default bunch has those record sets which doesn't fulfill any of the gathering conditions. For instance, on the off chance that you have made two gatherings for the channel conditions deptno=10 and dept=20 individually, then, at that point, those records which do not have deptno 10 and 20 will be passed into this default bunch. In short, the information which is dismissed by the channel gatherings will be gathered by this default bunch and at times there can be a necessity to store this dismissed information. In such situations, default yield gathering can be valuable.

In the complex landscape of data transformation and routing, the Router Transformation in Informatica stands as a powerful tool. It allows data professionals to direct data rows precisely based on defined conditions, ensuring that data flows seamlessly through the transformation process. In this article, we'll explore the significance, functionality, and practical applications of the Router Transformation in Informatica.

Understanding the Router Transformation

What is the Router Transformation?

The Router Transformation is a fundamental component within Informatica PowerCenter. Its primary function is to segregate data rows into multiple groups or "routes" based on specified conditions. Each condition defines a set of rules that determine which route a data row will follow.

Key Functions of Router Transformation

The Router Transformation offers several key functions:

  • Conditional Routing: It allows you to define conditions using expressions, and data rows are directed to routes that satisfy these conditions.
  • Multiple Routes: You can create multiple routes within a single Router Transformation, each with its own set of conditions. This enables complex data routing scenarios.
  • Data Splitting: The Router Transformation can split data into subsets, making it useful for parallel processing or directing data to different targets.

    Your gateway to success

Configuration and Usage

Configuration Steps

To configure the Router Transformation effectively, follow these steps:

1.     Create Ports: Define input and output ports for the Router Transformation. Input ports receive data rows, and output ports represent the different routes.

2.     Define Conditions: For each output port, define conditions using expressions. These conditions determine which data rows are directed to each route.

Practical Applications

The Router Transformation is versatile and finds applications in various scenarios:

  • Data Quality Control: You can route data rows that fail data quality checks to a separate route for further inspection or correction.
  • Data Segmentation: Route data based on attributes such as customer type, region, or product category for customized processing.
  • Error Handling: Send erroneous data rows to an error route for detailed analysis and troubleshooting.

Performance Considerations

Efficiency is crucial when working with the Router Transformation:

  • Optimize Conditions: Craft conditions carefully to minimize complexity and optimize performance. Complex conditions can impact processing speed.
  • Testing and Validation: Thoroughly test the Router Transformation and validate route assignments to ensure that data is directed correctly.

To permit numerous channel conditions, the switch change gives a bunch of choices.

Click here to explore

There is a default input bunch that takes input information

There is likewise a default yield bunch which gives that large number of information that isn't passed by any channel condition

For each channel condition, a result bunch is made in switch change. You can associate various focuses to these various gatherings.

Making Router Transformation

Stage 1 - Create planning having source "EMP" and target "EMP_TARGET."

Switch Transformation in Informatica with EXAMPLE

Stage 2 - Then in the planning

Select Transformation menu

Select make choice

Switch Transformation in Informatica with EXAMPLE

Stage 3 - In the make change window


Select switch change

Enter a name for the change "rtr_deptno_10"

Select Create choice

Stage 4 - The switch change will be made in the planning, select done choice in the window

Click here for details

Switch Transformation in Informatica with EXAMPLE


Stage 5 - Drag and drop every one of the sections from the Source qualifier to switch change

Switch Transformation in Informatica with EXAMPLE

Stage 6 - Double snap on the switch change, then, at that point, in the change property of it

Select gathering tab

Enter bunch name "deptno_20"

Click on the gathering channel condition

Switch Transformation in Informatica with EXAMPLE

Stage 7 - In the articulation supervisor, enter channel condition deptno=20 and select the OK button.

Switch Transformation in Informatica with EXAMPLE

Stage 8 - Select the OK button in the gathering window

Switch Transformation in Informatica with EXAMPLE

See also here -->>

Stage 9 - Connect the ports from the gathering deptno_20 of switch change to target table ports

Switch Transformation in Informatica with EXAMPLE

Presently, when you execute this planning, the separated records will get stacked into the objective table.


Read More :

Source Qualifier Transformation in Informatica
Introduction to Transformations in Informatica and Filter Transformation
Session Objects in Informatica
How to Debug Mappings in Informatica

Tags:

router transformation in informaticafilter vs router transformation in informaticadefault group in router transformation in informaticahow to use router transformation in informaticahow to create router transformation in informaticaproperties of router transformation in informaticadifference between union and router transformation in informaticarouter transformation in informatica interview questionshow to use router transformation in informatica cloudrouter transformation in informatica with examplerouter transformation in informatica scenariosrouter transformation in informatica active or passivesorter transformation in informatica bdmrouter transformation in informatica bdmdifference between filter and router transformation in informaticasorter transformation in informatica cloudrouter transformation in informatica cloudrouter transformation conditions in informaticarouter transformation in informatica developersorter transformation in informatica distinctsorter transformation in informatica developerhow to do router transformation in informaticarouter transformation in informatica examplesorter transformation in informatica exampleexample of router transformation in informaticawhat is router transformation in informaticafilter and router transformation in informaticarouter transformation functions in informaticarouter transformation in informatica guru99router transformation in informatica is active or passivesorter transformation in informatica interview questionssorter transformation in informatica is active or passiveinterview questions on router transformation in informaticawhy router is active transformation in informaticarouter transformation in informatica iicsrouter transformation in informatica jobrouter transformation in informatica javarouter transformation in informatica jdbcrouter transformation in informatica joinerrouter transformation in informatica jobs in usarouter transformation in informatica joinrouter transformation in informatica jsonrouter transformation in informatica kbrouter transformation in informatica knowledge baserouter transformation in informatica kafkarouter transformation in informatica key generatorrouter transformation in informatica keysorter transformation in informatica taking long timerouter transformation in informatica mdmrouter transformation in informatica mappingrouter transformation in informatica meaningrouter transformation in informatica mapping examplerouter transformation in informatica master and detailrouter transformation in informatica master and detail recordsrouter transformations in informatica metadatarouter transformations in informatica manyrouter transformation in informatica not workingrouter transformation in informatica networkrouter transformation in informatica noderouter transformation in informatica netapprouter transformation in informatica newlookuprow valuesrouter transformation in informatica null valuesrouter transformation in informatica naming conventionsrouter transformation in informatica naveenrouter transformation in informatica normalizerrouter transformation in informatica nesteduse of router transformation in informaticarouter transformation in informatica powercentersorter transformation in informatica powercentersorter transformation in informatica propertiessorter transformation in informatica to remove duplicateshow to use router transformation in informatica with examplesorter transformation in informatica with examplerouter transformation in informatica xpathrouter transformation in informatica xmlrouter transformation in informatica xpsrouter transformation in informatica xsltrouter transformation in informatica xml parserrouter transformation in informatica xml generatorrouter transformation in informatica xml source qualifierrouter transformation in informatica youtuberouter transformation in informatica youtube videorouter transformation in informatica youtube channelrouter transformation in informatica zapierrouter transformation in informatica zoominfo

Featured Universities

Mahatma Gandhi University

Location: Soreng ,Sikkim , India
Approved: UGC
Course Offered: UG and PG

MATS University

Location: Raipur, Chhattisgarh, India
Approved: UGC
Course Offered: UG and PG

Kalinga University

Location: Raipur, Chhattisgarh,India
Approved: UGC
Course Offered: UG and PG

Vinayaka Missions Sikkim University

Location: Gangtok, Sikkim, India
Approved: UGC
Course Offered: UG and PG

Sabarmati University

Location: Ahmedabad, Gujarat, India
Approved: UGC
Course Offered: UG and PG

Arni University

Location: Tanda, Himachal Pradesh, India.
Approved: UGC
Course Offered: UG and PG

Capital University

Location: Jhumri Telaiya Jharkhand,India
Approved: UGC
Course Offered: UG and PG

Glocal University

Location: Saharanpur, UP, India.
Approved: UGC
Course Offered: UG and PG

Himalayan Garhwal University

Location: PG, Uttarakhand, India
Approved: UGC
Course Offered: UG and PG

Sikkim Professional University

Location: Sikkim, India
Approved: UGC
Course Offered: UG and PG

North East Frontier Technical University

Location: Aalo, AP ,India
Approved: UGC
Course Offered: UG and PG