Data Integration uses the following data types in ActiveCampaign mappings, mapping tasks, and data transfer tasks:
ActiveCampaign native data types: ActiveCampaign data types appear in the fields tab for Source transformations when you choose to edit metadata for the fields.
Transformation data types: These data types are set of data types that appear in the remaining transformations. They are internal data types based on ANSI SQL92 generic data types, which Informatica Cloud uses to move data across platforms. Transformation data types appear in all transformations in a mapping.
When Secure Agent reads source data, it converts the native data types to the comparable transformation data types before transforming the data.