ODI Knowledge Modules Generate Incorrect Lengths for Teradata TIMESTAMP Datatype Columns
(Doc ID 849974.1)
Last updated on OCTOBER 05, 2023
Applies to:
Oracle Data Integrator - Version 10.1.3.2.0 to 11.1.1.9.99 [Release 10gR3 to 11gR1]Information in this document applies to any platform.
Symptoms
The Oracle Data Integrator (ODI) "LKM SQL to Teradata (TTU)" Knowledge Module generates a datatype of:
- TIMESTAMP(3) -- in the "Create work table" step, but a
- TIMESTAMP(26) -- in the "Create view on work table" step which is incorrect.
The Teradata view is created from the LKM "Create View on work table" step, as follows:
For example, this may happen when:
- Loading Microsoft SQLServer DATETIME field...
- Into Teradata TIMESTAMP(3) FORMAT 'YYYYMMDDHHMISS.S(3)' NOT NULL target...
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |