✍ Kashif M
Trends

Sunday, 10 August 2014


Mapping in Informatica


By on August 10, 2014



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.

Kashif
mkashu: Mapping in Informatica
Review : Kashif | Kashif
Update: August 10, 2014 | Rating: 4.5

Comment for "Mapping in Informatica"

0 comments

Post a Comment