Data Integration uses the following data types in mappings with Amazon DynamoDB V2:
Amazon DynamoDB V2 native data types
Amazon DynamoDB V2 data types appear in the Fields tab for Source and Target transformations when you choose to edit metadata for the fields.
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 mapping.
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.
You can edit the data types of the source and target DynamoDB fields to change the Amazon DynamoDB V2 native data type, transformation data type, precision, and scale of fields.