Rules for Handling Decimal Data
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