In a data warehouse, data mapping is the process of creating a link between two distinct data models' (named source and target) tables and attributes.
A source to target mapping document is the result of data mapping process. The most important information contained in such document are the relationships between source datastores fields and target datastore fields.

 

ODI Generator can use Source to Target mappings as input for creating Oracle Data Integrator mappings. It can process Source to Target mappings which use generic names for tables and files or the real qualified names of the corresponding ODI datastores. When generic names are used, ODI Generator can translate them to corresponding datastores names based on schema information present on its repository and information provided in code template.

 

Source to target mapping document example

 

Being able to use generic names, ODI Generator makes possible the clear separation of business rules from the technical aspects of a mapping. Source to target mapping documents do not have to include any technical information. The business analysts or developers which create these documents should take care only about the business rules.

 

Mapping expressions for technical fields, mapping physical characteristics, Knowledge Modules information should be kept out of source to target mappings. Such information can be stored in code templates.