Mappings in Informatica: Create, Components, Parameter, Variable

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.