Teradata datatype mapping
We match Teradata data types to Data Integration data types while extracting your data. If a data type is not supported, we will map it as a String type.
The following table shows the mapping of Teradata data types to Data Integration-compatible types:
| Teradata type | Data Integration type |
|---|---|
| INTEGER | INTEGER |
| SMALLINT | INTEGER |
| BIGINT | INTEGER |
| BOOLEAN | boolean |
| DECIMAL | FLOAT |
| BYTEINT | INTEGER |
| BYTE | STRING |
| VARBYTE | STRING |
| BLOB | STRING |
| FLOAT | FLOAT |
| NUMBER | FLOAT |
| DATE | DATE |
| TIME | TIME |
| TIMESTAMP | TIMESTAMP |
| INTERVAL_YEAR | INTEGER |
| INTERVAL_YEAR_TO_MONTH | STRING |
| INTERVAL_MONTH | INTEGER |
| INTERVAL_DAY | INTEGER |
| INTERVAL_DAY_TO_HOUR | STRING |
| INTERVAL_DAY_TO_MINUTE | STRING |
| INTERVAL_DAY_TO_SECOND | STRING |
| INTERVAL_HOUR | INTEGER |
| INTERVAL_HOUR_TO_MINUTE | STRING |
| INTERVAL_HOUR_TO_SECOND | STRING |
| INTERVAL_MINUTE | INTEGER |
| INTERVAL_MINUTE_TO_SECOND | STRING |
| INTERVAL_SECOND | FLOAT |
| PERIOD_DATE | STRING |
| PERIOD_TIME | STRING |
| PERIOD_TIMESTAMP | STRING |
| CHAR | STRING |
| VARCHAR | STRING |
| CLOB | STRING |
| XML | STRING |
| JSON | STRING |
| TDUDT | STRING |
| GEOMETRY | STRING |
| MBR | STRING |
| MBB | STRING |
