Data Integration uses complex files in synchronization tasks and mapping tasks with Hadoop Files Connector.
Data Integration uses the following data types in mappings, synchronization tasks, and mapping tasks with complex file:
Complex file data types
Complex file data types appear in the physical data object column properties.
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 mappings, synchronization tasks, and mapping tasks.
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.
The following table lists the complex file data types that Data Integration supports and the corresponding transformation data types: