Transcription

Router Transformation in Informatica –Multiple targetsIt is advanced to filter T/r. Router T/r returns both True and False Values, but the true values are returned toUser defined Group whereas False Values are returned to Default group. We can create any number of userdefined groups. The data which is not satisfying any user group will go default group.Router Transformation in Informatica is an ‘active transformation’ and it is advanced to filter transformation,Router transformation takes single input data (source) into multiple targets based on data condition applied foreach group. Router Transformation returns both True and False Values, but the true values are returned toUser defined Group whereas False Values are returned to Default group. We can create any number of userdefined groups. The data which is not satisfying any user group will go default group.Router Transformation can be created by 2 types of groups :Input group : Input group receives the data from source pipeline and have only one i/p group.Output group : User defined and default are the two types of O/P group.Router Transformation in InformaticaRouter Transformation has an advantage over using multiple filter condition because in Router transformation, arow is read once into the input group but evaluated multiple times based on the number of groups.FilterRouterSingle ConditionMultiple ConditionsSingle Targetmultiple targetsRejected record can’t be captured.Default group caches the rejected records.Route Transformation mapping diagram.

In this Informatica tutorial, we will learn about router transformation. Here we are going to create a mapping,where a row can be sent to one of the three different target tables ().Source table : EMPLOYEES.Target tables : TUTORIALKART EMPLOYEES SALES, TUTORIALKART EMPLOYEES NON SALES,TUTORIALKART EMPLOYEES ROOKIE.Router condition.Sales group : JOB ID ‘ST CLERK’.Non Sales group : JOB ID ‘FI ACCOUNT’ OR JOB ID ‘IT PROG’ OR JOB ID ‘FI MGR’Rookie group : DATE DIFF (SESSSTARTTIME, HIRE DATE, ‘dd’) 730Creating Router transformation.To create router transformation in Informatica, we must create ‘Mapping’. Before creating mapping, we mustimport source and target tables using source and target Analyzer.Creating Source Definition.Connect to Informatica Repository service by proving Informatica admin console credentials. Source definition(source table) can be created using Source analyzer. Open Informatica PowerCenter Designer Tools Source Analyzer and import source table into Workspace.Creating Target definition.Target definition(target table) can be created using Target Designer. Open target designer and create targettable TUTORIALKART EMPLOYEES SALES, TUTORIALKART EMPLOYEES NON SALES,TUTORIALKART EMPLOYEES ROOKIE.Creating Mapping for Router transformation.To create new mapping in Informatica PowerCenter, navigate to Mapping designer available in tools and click

To create new mapping in Informatica PowerCenter, navigate to Mapping designer available in tools and clickon create option. A new window will be opened, enter mapping name and click on OK button.Now, drag and drop source definition from source folder to Mapping workspace. Source qualifier is createdautomatically by designer.Creating Router Transformation in Informatica 10.0.1.To create router transformation in Informatica, go to transformation tab and select create option. Now a newwindow will be opened, enter unique name and click on OK button.Select required ports in source qualifier and drop those ports in Router transformation, connect the sourcedefinition with transformation using link column icon in the tool bar.To add groups in router transformation, double click on header and select groups tab to add new groups.

Ignore default group and add three new groups and add filter condition as shown below.Click on validate button to check entered condition is valid or not.

Enter group filter condition for sales, non sales and rookie groups as shown below.Click on Apply button and Ok.Now add all three target definition tables to the mapping and link the target definition from the correspondinggroups in router transformation as shown below.Save the Mapping.Create and run WorkflowAfter creating Mapping Successfully, we have to create and run workflow. Open Informatica PowerCenter

After creating Mapping Successfully, we have to create and run workflow. Open Informatica PowerCenterWorkflow manager and create new workflow.Creating Session.A session task must be created for our mapping, go to tasks tab and select create option. Enter name and clickon Done.Select a mapping to associate with the session, here we selected M TUTORIALKART EMPLOYEES .Next, we must configure session connections by editing session. Double click on session, navigate to Mappingtab and select connections.Click on down arrow and select relational database connections for sources and targets as shown below.Under Properties, the Target load type should be defaulted to Normal.

Click OK to close the Edit Tasks dialog box.Link Start to session as shown below.Save the workflow and click on run workflow.Monitoring Workflow.To monitor the status of the workflow, open Informatica PowerCenter workflow monitor and the status.Informatica Introduction Informatica Tutorial - Home What is Informatica? Informatica - Architecture. Informatica - PowerCenter Repository Service Informatica - What is PowerCenter Integration Service? What is PowerCenter Repository Manager What is informatica PowerCenter Designer? Informatica - Data Transformation Manager (DTM)

Informatica - DTM Threads Informatica - Load Balancing Different ETL tools in Informatica What is Mapping architect for Visio? Informatica - PowerCenter 10.0.1 Installation Step by Step Informatica - Creating Integration Service Creating Informatica Repository Service Configuring Client Domain in Informatica Learn how to create ODBC connections in Informatica Creating Source Analyzer in Informatica Creating Target designer in Informatica Create Users and Folders in Informatica Setting up Target Database in Informatica Learn and Create Workflows in Informatica Learn and Create Mapping in Informatica Learn and Create a session in Informatica Informatica PowerCenter Repository Backup / Restore stepsInformatica Transformations Introduction to Informatica transformations Aggregator Transformation Filter Transformation Lookup Transformation Rank Transformation Router Transformation Update Strategy Transformation Joiner Transformation Expression Transformation Source Qualifier Transformation Sorter Transformation Union Transformation Normalizer Transformation SQL Transformation

Sequence Transformation Stored Transformation Transaction Control Transformation XML Generator Transformation XML Parser Transformation