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

Sunday, 8 September 2013

Union Transformation in Informatica

By on 06:13:00

· Active Transformation

· Merges similar data coming from heterogeneous (Oracle,SQl Server) or homogenous sources.

· These data can be maintained in the formof flat files.

· Union uses UNION ALL function. It does not remove duplicates.

· Multiple input groups but only one output group (opposite to Router).

· Input and Output groups must have matching ports.

· It does not generate transactions (just combining).


1. Define Source Definition EMP(Oracle) and EMP_F (Flat file e.g. .txt file)

2. Create a .txt file EMP.txt

Go to Source Analyzer workspace, select Import from File option from the Sources menu.

3. Select the required file and click on OK

Define Target

Define Mapping

Drag Sources,Target and create a Transfn. T_UNION

By default, NEWGROUP (Blue many) and OUTPUT (grey only one) are created. There are no ports inside this blank object.

Edit UNION transformation.

Go to GROUPS tab – 

Create two Input Groups and give the INPUT group name as EMP_O and EMP_F.

In the mapping designer workspace we can now see the newly created groups.

Go to Group Ports tab and click on add new ports button.

Drag the inputs from SQ to UNION EMP_O. Likewise, drag the inputs from SQ to UNION EMP_F.

Project the output ports from output group to the target

Define Session,Workflow.

Edit the Session and in the Mappings tab mention the Source File Directory C:\ and Source Filename EMP.txt.

Output (Target table is having primary key here – so the 3 duplicate records have been rejected)

If the Target Table has no Primary Key (All duplicate records will also get populated)


  1. Great post!I am actually getting ready to across this information,i am very happy to this commands.Also great blog here with all of the valuable information you have.Well done,its a great knowledge.

    Hadoop Training in Chennai


Blog Archive


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 (1) OBIA (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)