Informatica - Power Center Basic Concepts

Power Center Introduction

·         Is a single, unified enterprise data integration platform 

·         that allows companies and government organizations of all sizes to access, discover, and integrate 

·         data from virtually any business system, in any format, and deliver that data throughout the enterprise at any speed An ETL Tool (Extract, Transform and Load)

Power Center Client Applications

Designer Tools – Create mappings

Mapping

A mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation.

Mappings represent the data flow between sources and targets. 

When the Integration Service 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 file.
Links.  Connect sources, targets, and transformations so the Integration Service can move the data as it transforms it.

·         A mapping can also contain one or more mapplet. A mapplet is a set of transformations that you are using in mappings.