Table of Contents

Search

  1. Preface
  2. Introduction to Oracle Connector
  3. Oracle connections
  4. Synchronization tasks with Oracle Connector
  5. Mappings and mapping tasks with Oracle Connector
  6. Replication tasks
  7. Troubleshooting
  8. Appendix A: Data type reference

Oracle Connector

Oracle Connector

Appendix A: Data type reference

Appendix A: Data type reference

Data Integration
uses the following data types in mappings and tasks with Oracle:
Oracle native data types
Oracle data types appear in the source
and target
transformations when you choose to edit metadata for the fields.
Transformation data types
Set of data types that appear in the transformations. They are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. Transformation data types appear in all transformations in a mapping.
When
Data Integration
reads source data, it converts the native data types to the comparable transformation data types before transforming the data.
When
Data Integration
writes to a target, it converts the transformation data types to the comparable native data types.

0 COMMENTS

We’d like to hear from you!