DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
This topic has been marked "Resolved."
Author Message
ffsw13



Group memberships:
Premium Members

Joined: 01 Feb 2016
Posts: 22
Location: USA
Points: 246

Post Posted: Thu Aug 17, 2017 2:22 pm Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
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

_________________
The UNIVERSE is vast and expansive
I never Metadata I didn't like
JRodriguez



Group memberships:
Premium Members

Joined: 19 Nov 2005
Posts: 391
Location: New York City
Points: 4122

Post Posted: Fri Aug 18, 2017 7:40 am Reply with quote    Back to top    

....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
Rate this response:  
Not yet rated
chulett

Premium Poster


since January 2006

Group memberships:
Premium Members, Inner Circle, Server to Parallel Transition Group

Joined: 12 Nov 2002
Posts: 42033
Location: Denver, CO
Points: 215738

Post Posted: Fri Aug 18, 2017 9:26 am Reply with quote    Back to top    

Exactly... an Oracle NUMBER with no precision or scale is stored internally as a FLOAT.

_________________
-craig

<this space for rent>
Rate this response:  
Not yet rated
ffsw13



Group memberships:
Premium Members

Joined: 01 Feb 2016
Posts: 22
Location: USA
Points: 246

Post Posted: Fri Aug 18, 2017 11:50 am Reply with quote    Back to top    

Got it and makes sense, Thanks guys!

_________________
The UNIVERSE is vast and expansive
I never Metadata I didn't like
Rate this response:  
Not yet rated
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum



Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours