Using ODBC Operator with Oracle DATE Fields - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities

Using ODBC Operator with Oracle DATE Fields

The following limitations apply when the ODBC Operator runs on z/OS, UNIX, and Windows platforms.

  • Whether the TruncateData flag is ON or OFF, the ODBC operator will truncate the Oracle Date to Teradata Date if the target column is mapped to INTDATE or ANSIDATE. If you don’t want to truncate the Oracle Date then you must map the target column to TIMESTAMP or CHAR(19).
  • Normal “DATE” fields in Oracle cannot copy correctly over to Teradata's DATE field (in ANSI mode).
  • On some non-Teradata Databases, the DATE column type does not equate to Teradata's ANSI Date field.
  • For example, on Oracle, the column type DATE is equivalent to the column type DATETIME, which has a format of YYYY-MM-DD HH:MM:SS (equivalent to a CHAR(19)). Teradata ANSI DATE has a format of YYYY-MM-DD (equivalent to CHAR(10)).