Salesforce data types appear in the Source

and Target

transformations when you choose to edit metadata for the fields.

Transformation data types are the set of data types that appear in the transformations. Transformation data types are internal data types based on ANSI SQL-92 generic data types, which

Data Integration

uses to move data across platforms. Transformation data types appear in all transformations in Mappings

,

synchronization

tasks,

replication

tasks,

masking

tasks,

and

mapping

tasks.

When

Data Integration

reads source data,

Data Integration

converts the native data types to the comparable transformation data types before transforming the data.

When

Data Integration

writes to a target,

Data Integration

converts the transformation data types to the comparable native data types.