Data Integration uses the following data types in Pinecone mappings in advanced mode:
The following table lists the Pinecone data types that are compatible with Data Integration and the corresponding transformation data types:
•Pinecone native data types that are inherent to the Pinecone database.
•Transformation data types. Set of data types that appear in the transformations. These are internal data types based on ANSI SQL-92 generic data types, which the agent uses to move data across platforms. They appear in all transformations in a mapping in advanced mode.
When the agent writes to a Pinecone target, it converts the transformation data types to the comparable native data types.