Hi, I'm Ask INFA!
What would you like to know?
ASK INFAPreview
Please to access Ask INFA.

Table of Contents

Search

  1. Preface
  2. Introduction to Microsoft Azure Data Lake Storage Gen2 Connector
  3. Connections for Microsoft Azure Data Lake Storage Gen2
  4. Mappings for Microsoft Azure Data Lake Storage Gen2
  5. Migrating a mapping
  6. Data type reference
  7. Troubleshooting

Microsoft Azure Data Lake Storage Gen2 Connector

Microsoft Azure Data Lake Storage Gen2 Connector

Data type reference

Data type reference

Data Integration uses the following data types in
Microsoft Azure Data Lake Storage Gen2
mappings and mapping tasks:
  • Microsoft Azure Data Lake Storage Gen2
    native data types appear in the Source transformation
    and Target transformation
    when you choose to edit metadata for the fields.
  • Transformation data types. Set of data types that appear in the transformations. These are internal data types based on ANSI SQL-92 generic data types, which the Secure Agent uses to move data across platforms. They appear in all transformations in a mapping.
When the Secure Agent reads source data, it converts the native data types to the comparable transformation data types before transforming the data.
When the Secure Agent writes to a target, it converts the transformation data types to the comparable native data types.
The following table lists the
Microsoft Azure Data Lake Storage Gen2
data types that
Data Integration
supports and the corresponding transformation data types:
Microsoft Azure Data Lake Storage Gen2
Native Data Type
Transformation Data Type
Description
String
String
1 to 104,857,600 characters

0 COMMENTS

We’d like to hear from you!