Rules for Handling Decimal Data - Parallel Transporter

Teradata® Parallel Transporter Reference

Product
Parallel Transporter
Release Number
17.00
Published
November 2020
Language
English (United States)
Last Update
2022-02-03
dita:mapPath
ric1544831938741.ditamap
dita:ditavalPath
obe1474387269547.ditaval
dita:id
B035-2436
lifecycle
previous
Product Category
Teradata Tools and Utilities
The following rules apply to the ODBC Operator running on z/OS, UNIX, and Windows platforms, when taking DECIMAL data from a non-database system (such as Oracle) and moving it to a database system.
  • 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 0s (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