Thanks all for your help.
I didn't find the way to avoid the warning in datastage. The alternative solution is to change in the target database (Oracle) the type of my columns from NUMBER to NUMBER(38,10).
Search found 2 matches
- Wed Jan 28, 2009 4:13 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warning on insert decimal with oracle stage load append mode
- Replies: 4
- Views: 3082
- Fri Jan 23, 2009 11:15 am
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: warning on insert decimal with oracle stage load append mode
- Replies: 4
- Views: 3082
warning on insert decimal with oracle stage load append mode
Hi all, I have a target oracle table with a few columns declared as NUMBER. I'm getting a warning in the execution of the job that inserts data to this table. the warning is " When checking operator: Column ID_CONTRAT floating point decimal not fully supported. Adjusting scale. " the colum...