Oracle Business Intelligence Application Architect
☎ +91 9994883085
Don't miss

Sunday, 8 September 2013

Router Transformation in Informatica


By on 03:29:00


Active Transformation.

It is used to filter the data like the filter transformation.

Router allows to filter with multiple conditions and project data to multiple targets.

Unlike the Filter, Router allows rejected data also. It captures the rejected data in a default group.

Router allows one input and sends it to many outputs.

Steps:

Define Source

Define Targets (multiple targets).

Create the mapping .Drag Source (EMP) and Targets (Dim_EMP,DIM_EXP,DIM_RANK for practice only) to the Mapping Designer.

In the Transformation Menu select ROUTER and click on Create. Give the name as T_ROUT.
Click on Create and then Done.


Project the required ports from the Source Qualifier to Router. An INPUT GROUP is prepared.




Edit the Router and go to Groups Tab.

Add a new Group.




Note: When we add a new group for the first time, by default it prepares a default group. Default group is created only once.



Add another Group NEWGROUP1.




Give Group names and then specify the group filter condition.

Apply and then OK.




All the Groups (INPUT, DEPTNO10, SAL_GT_2000, DEFAULT) can now be seen in Router.



Default Group contains the rejected data.

Example:
EMPNO
EMPNAME
SAL
DEPTNO
1
X
2000
10
2
Y
3000
10
3
Z
4000
20
4
A
3000
10

Condition1:  Deptno = 10 -> 3 records satisfy the 4th record goes to the Default Group.

Condition2: Sal > 2000 the record in the Default Group satisfies this condition and so it is now removed.

Rejected record is now 1 X 2000 10

Note: For a record in the default Group it should satisfy neither condition.

Now Project the required ports from ROUTER OUTPUT to Multiple TARGETS.



We can also project the default data if needed.

Save the repository.

Define the Session,workflow,Start workflow and preview the data.







Note: In Router Transformation we may get more no. of records in the Target than the source.

Example: Source Rows 14, Target Rows 16

(See the screen shot)



4 comments:

  1. In a router if group1 is dept>10 and group2 is dept>20 ..and incoming value has dept=30..which grooup it will fall?

    ReplyDelete

Blog Archive

Labels

1z0-482 Dumps (2) 1Z0-525 Dumps (1) BI Apps Installation (1) BI Publisher Interview Questions (1) BICS (2) Business Intelligence (1) DATA WAREHOUSE ADMINISTRATOR CONSOLE (18) Data Warehousing (48) E-BIZ R12 (1) E-BIZ R12 INSTALLATION (1) Essbase (1) hmailserver (1) Hyperion (1) Hyperion Essbase (2) Hyperion Essbase Interview Questions (1) Hyperion financial management (1) Informatica (163) Informatica Installation 9.6.1 (2) Informatica Interview Question (46) Informatica Online Training (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA 11.1.1.7.1 (1) OBIA 7.9.6.3 (3) OBIA Installation (33) OBIEE (1) OBIEE 10G (8) OBIEE 11G (137) OBIEE 11g dumps (2) OBIEE 11g Interview Questions (1) OBIEE 12c (20) OBIEE 12c Architecture (1) OBIEE 12C TRAINING (1) OBIEE certification (2) OBIEE Interview Question (1) OBIEE Publisher Interview Questions (1) OBIEE TRAINING CHENNAI (1) OBIEE TRAINING ONLINE (1) ODI (Oracle data integrator) (2) odi 11g certification (1) ODI dumps (2) Oracle Administrator (20) Oracle Business Intelligence Application (3) Oracle Data Integrator (2) Oracle Data Integrator Interview questions for experience (1) Oracle Database (3) Oracle Database 12c Installation steps (3) Oracle Database Installation in Linux 6 (2) Oracle E-Business R 12.3 (1) Oracle Hyperion Planning and Budgeting Questionnaire (2) oracle Joins (1) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)