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
Oracle OCI Decimal(38) versus Connector DOUBLE
Moderators: chulett, rschirm, roy
Oracle OCI Decimal(38) versus Connector DOUBLE
The UNIVERSE is vast and expansive
I never Metadata I didn't like
I never Metadata I didn't like
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
....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
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses