Sunday, December 30, 2012

Informatica Mapping design process/steps


The Design Process

The goal of the design process is to create mappings that depict the flow of data between sources and targets, including changes made to the data before it reaches the targets. However, before you can create a mapping, you must first create or import source and target definitions. You might also want to create reusable objects, such as reusable transformations or mapplets. For a list of objects you create in the Design process, see Repository Objects.
Perform the following design tasks in the Designer:
1.     Import source definitions. Use the Source Analyzer to connect to the sources and import the source definitions.
2.     Create or import target definitions. Use the Warehouse Designer to define relational, flat file, or XML targets to      receive data from sources. You can import target definitions from a relational database or a flat file, or you can manually create a target definition.
3.     Create the target tables. If you add a target definition to the repository that does not exist in a relational database,      you need to create target tables in your target database. You do this by generating and executing the necessary SQL code within the Warehouse Designer.
4.     Design mappings. Once you have source and target definitions in the repository, you can create mappings in the Mapping Designer. A mapping is a set of source and target definitions linked by transformation objects that define the rules for data transformation. A transformation is an object that performs a specific function in a mapping, such as looking up data or performing aggregation.
5.     Create mapping objects. Optionally, you can create reusable objects for use in multiple mappings. Use the Transformation Developer to create reusable transformations. Use the Mapplet Designer to create mapplets. A mapplet is a set of transformations that may contain sources and transformations.
6.     Debug mappings. Use the Mapping Designer to debug a valid mapping to gain troubleshooting information about data and error conditions.
7.     Import and export repository objects. You can import and export repository objects, such as sources, targets, transformations, mapplets, and mappings to archive or share metadata. 

1 comment:

Thank you :
- kareem