Effective in version 10.0, you can create mappings with dynamic sources and targets that allow metadata changes to the data sources. When you configure a source or target to be dynamic, the Data Integration Service can interpret metadata changes to relational and flat file data sources at run time.

The Data Integration Service can perform the following functions:

Read data from sources where the order of the columns in the source is different from that of the columns in the physical data object.
Read data from additional columns in sources that are not present in the physical data object.
Ignore data for columns that are present in the physical data object but not in the source.

For relational data sources, the Data Integration Service directly fetches the metadata changes from the database schema.

For flat file data sources, you must configure the flat file data object for the Data Integration Service to fetch the metadata changes from the data file header, a control file, or automatically from the columns in the data source. Configure the

Generate Run-time Column Names

property on the

Advanced

tab of the flat file data object.

When you develop a mapping, configure the Read and Write transformations to get data object columns directly from the data sources at run time. You can also configure the Lookup transformations to get data object columns directly from the lookup sources. Select

At run time, get data object columns from data source

on the

Data Object

tab of the transformation.

For more information, see the "Dynamic Mappings" chapter in the

Informatica 10.0 Developer Mapping Guide

.