Table of Contents

Search

  1. Preface
  2. Informatica Developer
  3. The Model Repository
  4. Searches in Informatica Developer
  5. Connections
  6. Physical Data Objects
  7. Flat File Data Objects
  8. Logical View of Data
  9. Viewing Data
  10. Application Deployment
  11. Application Patch Deployment
  12. Application Patch Deployment Example
  13. Continuous Integration and Continuous Delivery (CI/CD)
  14. Object Import and Export
  15. Appendix A: Data Type Reference
  16. Appendix B: Keyboard Shortcuts
  17. Appendix C: Connection Properties

Developer Tool Guide

Developer Tool Guide

Application Properties

Application Properties

After you create an application, you can edit properties in the
Application
editor.

General Application Properties

The following table describes general application properties that you can set on the
Overview
tab:
Property
Description
Name
Name of the application.
Description
Optional. Description of the application.
Application Type
Type of application. Full or incremental.

Mapping Deployment Properties

The following table describes the mapping deployment properties that you can set on the
Advanced
tab when the application contains a mapping:
Property
Description
Default date time format
Date/time format that the Data Integration Service 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 does not override the tracing level that you set for each transformation.
  • Terse. The Data Integration Service logs information about initialization, error messages, and notification of rejected data.
  • Normal. The Data Integration Service logs information about initialization and status, errors encountered, and skipped rows due to transformation row errors. The Data Integration Service 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. The log notes where the Data Integration Service truncates string data to fit the precision of a column. The log contains detailed transformation statistics. The Data Integration Service writes row data for all rows in a block when it processes a transformation.
To view Spark engine information in the workflow log, select Verbose Initialization or Verbose Data in the Developer tool.
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.

0 COMMENTS

We’d like to hear from you!