Native data types are data types specific to the source
and target
databases or flat files. They appear in non-SAP sources
and targets
in the mapping.
SAP data types
SAP data types appear in the Fields tab for Source
and Target
transformations when you choose to edit metadata for the fields. SAP performs any necessary conversion between the SAP data types and the native data types of the underlying source database tables.
Transformation data types
Set of data types that appear in the remaining transformations. They 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 remaining transformations in a mapping
,
synchronization
task
, or
mapping
task.
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.
ASK INFAPreview
