Table of Contents

Search

  1. Preface
  2. Mappings
  3. Mapplets
  4. Mapping Parameters
  5. Where to Assign Parameters
  6. Mapping Outputs
  7. Generate a Mapping from an SQL Query
  8. Dynamic Mappings
  9. How to Develop and Run a Dynamic Mapping
  10. Dynamic Mapping Use Cases
  11. Mapping Administration
  12. Export to PowerCenter
  13. Import From PowerCenter
  14. Performance Tuning
  15. Pushdown Optimization
  16. Partitioned Mappings
  17. Developer Tool Naming Conventions

Developer Mapping Guide

Developer Mapping Guide

Mapping Configuration Properties

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.
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:
Auto
The Data Integration Service applies optimizations based on the execution mode and mapping contents.
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.
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 Auto.
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.

0 COMMENTS

We’d like to hear from you!