16.10 - Rules for Handling Decimal Data - Parallel Transporter

Teradata Parallel Transporter Reference

Product
Parallel Transporter
Release Number
16.10
Published
July 2017
Content Type
Programming Reference
Publication ID
B035-2436-077K
Language
English (United States)

The following rules apply to the ODBC Operator running on z/OS, UNIX, and Windows platforms, when taking DECIMAL data from non-Teradata Databases (such as Oracle) and moving it to Teradata Database.

  • If the precision values between the source and target tables are not equal, the data will be checked at runtime. If the data does not fit, the job will be terminated.
  • If the scale factors do not match, one of the following will happen:
    • If the source scale factor is less than the target, then Teradata PT will add 0’s (zeros) to the end of the source scale factor until they do match, and then the job will continue.

      or,

    • If the source scale factor is greater than the target, the job will terminate before attempting to process the data, due to possible loss of data.
  • For source column NUMBER (m, n) and target column DECIMAL (M, N), the job will do the following:
    • Terminate with error if n>N
    • Run if n<N or n=N
    • Run if m<=M, assuming n<N or n=N
    • Attempt to run if m>M, assuming n<N or n=N