Datatype Reference Overview
Informatica Cloud uses the following datatypes in mappings, Data Synchronization tasks, and Mapping Configuration tasks with Qlik:
- Qlik native datatypes
- Qlik data types appear in the Target transformations when you choose to edit metadata for the fields.
- Transformation datatypes
- Set of datatypes that appear in the transformations. They are internal datatypes based on ANSI SQL-92 generic datatypes, which the agent uses to move data across platforms. Transformation data types appear in all transformations in a mapping.
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 datatypes.