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
how to import/manually code Number datatype(Oracle) into DS
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 8
- Joined: Tue Feb 10, 2004 8:06 am
Re: how to import/manually code Number datatype(Oracle) into
Change it manually to e.g. Decimal(40,0)
Ogmios
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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
![Image](http://www.worldcommunitygrid.org/images/logo.gif)