DSXchange

Hi all,

Got some problems with OCI decimals.
My job is OCI => dataset
My select is basic and do not have any conditions and i just take three key columns not nullable.
I import metadata and let DS choose columns type.
First is decimal 6, second is varchar and last one decimal 11.
In the DB source, i have 3273 in the 3rd column and in output, i found 32731.
I don't have any warnings neither aborts.
If i do a to_char in the select it runs ok.

Don't understand.

Importing table definitions through OCI is known to be inaccurate for decimal data type. Even IBM recommends that you import Oracle table definitions using Orchestrate (the orchdbutil utility).

please could you provide more values where you are facing problem, just to analyze the data, may be something related to trunc or rounding of values, or may be something as suggested by ray.