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

Thursday, 5 September 2013

Steps to use Filter Transformation in Informatica

By on 11:54:00

Define the Source (EMP)

Define the Target (DIM_EMP)

Create the Mapping.

Drag Source definition and Target definition to the Mapping Designer Workspace.

Go to the Transformation Menu and click on Create.

Select the Transformation type to create (Filter)

Give a name to the transformation (T_FIL) and click on Create and then Done

A blank object appears on the Mapping Designer Window.

Select the required ports from the Source Qualifier (by using Ctrl key).Drag and drop on the filter transformation.

Right click the Transformation object and click on edit or select Edit option from the Transformations menu.

Check the Make reusable box.

Click on the Properties tab and click the Filter condition down arrow button

Expression editor appears - remove TRUE from the formula bar.

Click on Ports tab and then in the expression editor and give the condition.

Click on Validate.

Project the required ports from the filter to the target.

Repository -> Save.

Open the  WorkFlow Manger.

Define Session.

Define Workflow.

Start the Workflow.

In the Task Developer edit session got to Mappings tab.

Select the dimension table from the Targets folder and then in the Properties window check the Truncate Target Table option. Apply and then OK.

Now go to Informatica Designer. Right click on the target table DIM_EMP and select the option Preview Data.

Give the database credentials and click on Connect, the result dataset is shown up.


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 (47) Informatica Online Training (1) informatica scenarios questions (1) Informatica Training (1) Informatica Training Chennai (1) JAVA (1) linux (1) Normalization in Oracle (1) OBIA (1) OBIA (3) OBIA Installation (33) OBIEE (2) OBIEE 10G (8) OBIEE 11G (138) 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) Power BI (5) RCU INSTALLATION (1) scorecard in obiee 11g (1) SQL (3) SQL Interview Questions (1) sql server 2008 (2) Sql server installation (1) WinSCP (1)