Mapping Configurations
A mapping configuration controls the mapping deployment properties that the Developer tool uses when you run a mapping.
You can configure a default mapping configuration, a reusable mapping configuration, or a custom mapping configuration. The default mapping configuration specifies the default mapping properties. The Data Integration Service uses the default mapping configuration to run a mapping unless a reusable or custom mapping configuration is specified.
The following table describes the mapping configuration types:
Mapping Configuration | Description |
|---|
Default mapping configuration | The default mapping configuration defines the default mapping deployment properties. The Data Integration Service runs a mapping using the default mapping configuration unless a reusable or custom mapping configuration is specified. Configure a default mapping configuration in the Developer tool preferences. |
Reusable mapping configuration | Use a reusable mapping configuration to override the default mapping configuration when you run a mapping. The mapping configuration persists for the current mapping run. Configure a reusable mapping configuration in the Run Configurations dialog box. Select the mapping configuration and run the mapping through the Run Configurations dialog box, or select the mapping configuration when you run the mapping using advanced options. You must select the mapping configuration each time that you run a mapping. |
Custom mapping configuration | Use a custom mapping configuration to override the default mapping configuration when you run a mapping. The custom mapping configuration properties include only the Data Integration Service, operating system profile for the Data Integration Service, override tracing level, and optimizer level. The custom mapping configuration persists for the current mapping run. Configure a custom mapping configuration in the Run Mapping Using Advanced Options dialog box. You must reconfigure the custom mapping configuration each time that you run a mapping. |
Mapping Configuration Properties
Configure a mapping configuration in the Run Configurations dialog box, or configure a default mapping configuration in the Developer tool preferences. The properties that you can configure for the mapping include Data Integration Service properties, source properties, and advanced properties.
Data Integration Service Propeties
The following table displays the properties that you configure for the Data Integration Service:
Property | Description |
|---|
Use the default Data Integration Service | Uses the default Data Integration Service to run the mapping. Default is enabled. |
Data Integration Service | Specifies the Data Integration Service that runs the mapping if you do not use the default Data Integration Service. |
Available operating system profiles | Specifies the operating system profile to run the mapping when the Data Integration Service is enabled to use operating system profiles. The Developer tool displays this property only if the administrator assigned at least one operating system profile to the user. The Data Integration Service runs the mapping with the default operating system profile assigned to the user. You can change the operating system profile from the list of available operating system profiles. |
Source Properties
The following table displays the properties that you configure for sources:
Property | Description |
|---|
Read all rows | Reads all rows from the source. Default is enabled. |
Read up to how many rows | Specifies the maximum number of rows to read from the source if you do not read all rows. Note: If you enable the this option for a mapping that writes to a customized data object, the Data Integration Service does not truncate the target table before it writes to the target. Default is 1000. |
Read all characters | Reads all characters in a column. Default is disabled. |
Read up to how many characters | Specifies the maximum number of characters to read in each column if you do not read all characters. The Data Integration Service ignores this property for SAP sources. Default is 4000. |
Advanced Properties
The following table displays the advanced properties:
Property | Description |
|---|
Default date time format | Date/time format the Data Integration Services uses when the mapping converts strings to dates. Default is MM/DD/YYYY HH24:MI:SS. |
Override tracing level | Overrides the tracing level for each transformation in the mapping. The tracing level determines the amount of information that the Data Integration Service sends to the mapping log files. Choose one of the following tracing levels: - - None. The Data Integration Service uses the tracing levels set in the mapping.
- - Terse. The Data Integration Service logs initialization information, error messages, and notification of rejected data.
- - Normal. The Data Integration Service logs initialization and status information, errors encountered, and skipped rows due to transformation row errors. Summarizes mapping results, but not at the level of individual rows.
- - Verbose initialization. In addition to normal tracing, the Data Integration Service logs additional initialization details, names of index and data files used, and detailed transformation statistics.
- - Verbose data. In addition to verbose initialization tracing, the Data Integration Service logs each row that passes into the mapping. Also notes where the Data Integration Service truncates string data to fit the precision of a column and provides detailed transformation statistics.
Default is None. |
Sort order | Order in which the Data Integration Service sorts character data in the mapping. Default is Binary. |
Optimizer level | Controls the optimization methods that the Data Integration Service applies to a mapping as follows: - None
- The Data Integration Service does not apply any optimization.
- Minimal
- The Data Integration Service applies the early projection optimization method.
- Normal
- The Data Integration Service applies the early projection, early selection, branch pruning, push-into, global predicate optimization, and predicate optimization methods. Normal is the default optimization level.
- Full
- The Data Integration Service applies the cost-based, early projection, early selection, branch pruning, predicate, push-into, semi-join, and dataship-join optimization methods.
Default is Normal. |
High precision | Runs the mapping with high precision. High precision data values have greater accuracy. Enable high precision if the mapping produces large numeric values, for example, values with precision of more than 15 digits, and you require accurate values. Enabling high precision prevents precision loss in large numeric values. Default is enabled. |
Send log to client | Allows you to view log files in the Developer tool. If you disable this option, you must view log files through the Administrator tool. Default is enabled. |
How to Configure the Default Mapping Configuration
Update the default mapping configuration properties in the Developer tool preferences. The Developer tool uses the default mapping configuration properties to run mappings if no mapping configuration is specified.
1. In the Developer tool, click Windows > Preferences.
The Preferences dialog box appears.
2. Navigate to Informatica > Run Configurations > Mapping.
3. Configure the default mapping configuration properties.
4. Click OK.
The Developer tool updates the default mapping configuration properties.
How to Create a Reusable Mapping Configuration
Create a reusable mapping configuration in the Run Configurations dialog box. Specify the mapping configuration properties. Select the mapping configuration when you run a mapping in the Developer tool.
1. In the Developer tool, click Run > Open Run Dialog.
The Run Configurations dialog box appears.
2. Right-click Mapping Configuration and select New.
3. Select the new mapping configuration.
4. Enter the mapping configuration name.
5. Configure the mapping configuration properties.
How to Create and Use a Custom Mapping Configuration
Configure a custom mapping configuration before you run a mapping using advanced options. You must reconfigure the custom mapping configuration each time that you run the mapping.
1. In the Developer tool, right-click a mapping in the editor or the Object Explorer view. Select Run Mapping Using Advanced Options.
The Run Mapping Using Advanced Options dialog box appears.
2. Select Specify a custom mapping configuration.
3. Configure the custom mapping configuration properties. Specify the Data Integration Service, operating system profile for the Data Integration Service, override tracing level, and optimizer level.
4. Click Run.
The mapping runs using the custom mapping configuration.