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

Sunday, 10 August 2014

Mapping in Informatica


By on 05:04:00



Mappings in Informatica Overview:
Mappings represent the data flow between sources and targets. When the Informatica Server runs a session, it uses the instructions configured in the mapping to read, transform, and write data. Every mapping must contain the following components: 

  • Source definition. Describes the characteristics of a source table or file. 

  • Transformation. Modifies data before writing it to targets. Use different transformation objects to perform different functions. 

  • Target definition. Defines the target table or flat file. 

  • Connectors. Connect sources, targets, and transformations so the Informatica Server can move the data as it transforms it.
A mapping can also contain one or more mapplets. A mapplet is a set of transformations that you build in the Mapplet Designer and can use in multiple mappings. When you add an object to a mapping, you configure the properties according to the way you want the Informatica Server to transform the data. You also connect the mapping objects according to the way you want the Informatica Server to move the data. You connect the objects through ports. The Mapping Designer displays objects in three different views: 

Mapping in Informatica
Mapping in Informatica
  • Iconized. Shows an icon of the object with the object name. 

  • Normal. Shows the columns in the ports tab and the input and output port indicators. You can connect objects that are in the normal view. 

  • Edit. Shows the object properties. You can switch between the different tabs and configure the object in this view.

Mappings represent the data flow between sources and targets. When the Informatica Server runs a session, it uses the instructions configured in the mapping to read, transform, and write data. Every mapping must contain the following components: 

Source definition
. Describes the characteristics of a source table or file. 

Transformation. Modifies data before writing it to targets. Use different transformation objects to perform different functions. 

Target definition. Defines the target table or flat file.
Connectors. Connect sources, targets, and transformations so the Informatica Server can move the data as it transforms it.

A mapping can also contain one or more mapplets. A mapplet is a set of transformations that you build in the Mapplet Designer and can use in multiple mappings. When you add an object to a mapping, you configure the properties according to the way you want the Informatica Server to transform the data. You also connect the mapping objects according to the way you want the Informatica Server to move the data. You connect the objects through ports. 
 
The Mapping Designer displays objects in three different views:
 
Iconized. Shows an icon of the object with the object name. 

Normal. Shows the columns in the ports tab and the input and output port indicators. You can connect objects that are in the normal view. 

Edit. Shows the object properties. You can switch between the different tabs and configure the object in this view.

0 comments:

Post a Comment

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)