Mappings in Informatica: Create, Components, Parameter, Variable

Jose Angel Ovando Quintero
Note by , created over 2 years ago

Introduction to mappings in Informatica PowerCenter

Jose Angel Ovando Quintero
Created by Jose Angel Ovando Quintero over 2 years ago
Estefanny Ipanaq
¿Por cuál votas?
Lidia Fabián Acevedo
Biology Unit 1
PuKW STEP6 - Hummel
Antonia Ilieva
Business Intelligence
Aaron Sanabria
La búsqueda de Dios a través de la naturaleza
Karla Vale Manrique
Business Intelligence Competency Center
Disciplinas y tecnicas relacionadas al BI
César Iván Quiroz Esparza
SSD BI para las Pymes
Rosa Mariia Flores

Page 1

Mapping - Mapping is a collection of source and target objects linked together by a set of transformations.  Source Definition - Defines the structure and characteristics of the source. Transformation - Defines how the data is transformed, various functions can apply. Target Definition - Defines where the data will be loaded Links - They connect source with transformation and with target.

Components of Mappings Source tables Mapping parameters and variables Target objects Mapping transformations​​​​​​​​​​​​​​ Mapping Source : Mapping sources are the objects from where you fetch the source data. It can be a database, flat file, XML source or COBOL file source Mapping target:  Mapping target is our destination where final processed data gets loaded. Mapping target can be a relational table of a database, a flat file or XML file. Sources and targets are mandatory in any mapping, their type can differ Mapping Parameters and Variables : Mapping parameters and variables helps you to create temporary variables that will help you define and store temporary values ​​while mapping data processing. Mapping parameters and variables are optional users defined data types, which can be created for mapping and can be referenced and updated for a specific requirement. We will learn more about mapping parameters and variables in this section Mapplets : They are objects which consist of a set of transformation, source or targets. Mapplets are generally created to reuse the existing functionality of a set of transformations. It can be used in any of the mappings.