Data Type Reference Overview
Informatica Cloud uses the following data types in mappings, Data Synchronization tasks, and Mapping Configuration tasks with Microsoft Azure Data Lake:
- Microsoft Azure Data Lake native data types
- Microsoft Azure Data Lake 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 mappings and Data Synchronization tasks.
- When Informatica Cloud reads source data, it converts the native data types to the comparable transformation data types before transforming the data. When Informatica Cloud 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 data types that Informatica Cloud supports and the corresponding transformation data types:
Microsoft Azure Data Lake Native Data Type | Transformation Data Type | Description |
|---|
String | String | 1 to 104,857,600 characters |