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.


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


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


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

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.

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