DSXchange

Hi

In our back end, one of the columns is defined as Number(NO Precision and NO scale given).When metadata is imported, DS takes it as Decimal(38,0).
In practice, we require the Scale very much, and the job gives warnings

Any suggestions on how to tckle this?

Ameet

Change it manually to e.g. Decimal(40,0)

Ogmios

Hi and welcome aboard.
what is you import method (ODBC or plugin)?, if you use ODBC try using native plugin.
what do you see when you extract the table's meta data via the DB tools in that column's definition?
In My Humble Opinion defining numeric/decimal columns as default percision and scale is not good practice but some people mihgt think otherwise.
if the actual DDL has only numeric and no scale/percision you can try getting the DBA's to change it or manualy change your table definitions to meet your needs (as already said).

IHTH,