Decimal Datatype

AnushaReddy · Post by **AnushaReddy** » Thu Feb 27, 2014 5:01 am

Hi,

There is a oracle table which has below column

"DEP_ID" Decimal(22,5)

But while reading data from the table using datastage i have declared metadata in the "ORACLE CONNECTOR" as Decimal(22,2)

My concern is will it just truncate the rest of the decimal part or will it round off?

Data in the table " 23.56789"

When read using datastage will it be 23.56 or 23.57

anbu · Post by **anbu** » Thu Feb 27, 2014 5:41 am

Why dont you run the job and see the result?

priyadarshikunal · Post by **priyadarshikunal** » Thu Feb 27, 2014 6:10 am

there is a environment variable for that, have a look.

why not read the value as it is and then round or truncate as your job logic. This gives you more control over the data.

AnushaReddy · Post by **AnushaReddy** » Thu Feb 27, 2014 6:11 am

I am able to see the data is being round off to the nearest value.
So need help to prevent this.

Input : 123.448

Output as per data stage job : 123.45

Output expected is : 123.44

anbu · Post by **anbu** » Thu Feb 27, 2014 6:18 am

Use oracle function trunc

Code: Select all

TRUNC(123.448, 2)

2 is the number of decimal places to truncate to

chulett · Post by **chulett** » Thu Feb 27, 2014 7:47 am

Or select it with the proper scale and then use DecimalToDecimal() within the job to truncate it during the conversion to the lower scale.

ray.wurlod · Post by **ray.wurlod** » Thu Feb 27, 2014 2:14 pm

Learn about the rtype option that goes with these conversion functions to specify how you want the value to be rounded.