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

Advanced Properties

Advanced Properties

The Developer tool displays the
Advanced
tab for data viewer, mapping, and web service configurations.
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!