Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Timestamp column issue in moving data from File to Teradata

1004130Apr 21 2013 — edited Apr 23 2013

Hi,

I have an interface which moves data from File to Teradata. One of the columns in the File is Date column. When I run the interface, ODI is throwing an error as follows in 'Create work table' step.

*[Error 5401] [SQLState HY000] Number of fractional digits out of range.*

Any help is greatly appreciated.

Thank you very much

Regards,
Reyas

Locked Post

New comments cannot be posted to this locked post.

Locked on May 21 2013

Added on Apr 21 2013

#business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

9 comments

2,062 views