Table of Contents

Search

  1. Preface
  2. Part 1: 10.2
  3. Part 2: Version 10.1.1
  4. Part 3: Version 10.1
  5. Part 4: Version 10.0
  6. Part 5: Version 9.6.1
  7. Part 6: Version 9.6.0

Generate Relational and Flat File Metadata at Run Time

Generate Relational and Flat File Metadata at Run Time

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
.


Updated August 28, 2020