Page 1 of 1
Oracle OCI Decimal(38) versus Connector DOUBLE
Posted: Thu Aug 17, 2017 2:22 pm
by ffsw13
IHAC who would like to know why Oracle database NUMBER type that used to import into DataStage via the Oracle OCI Stage as Decimal 38, now come in as DOUBLE via the Oracle Connector.. Any takers?
TIA,
ff
Posted: Fri Aug 18, 2017 7:40 am
by JRodriguez
....DataStage does not have a data type that match Oracle Number without precision and scale, in your case the scale is not present. DataStage will represent them as double to correctly indicates that this might be a floating point number
Posted: Fri Aug 18, 2017 9:26 am
by chulett
Exactly... an Oracle NUMBER with no precision or scale is stored internally as a FLOAT.
Posted: Fri Aug 18, 2017 11:50 am
by ffsw13
Got it and makes sense, Thanks guys!