Decimal Datatype

[idw2ty]

Can someone explain to me why datastage seems to default all numbers to the decimal datatype? I am using Oracle tables, with columns all defined as number and all integers, but it seems as though datastage trys to make the integers into decimals. I get a lot of warnings about scale, when my numbers have no scale. Any help I could get so I can stop the warnings would be appreciated. Thanks.

[singhald]

hello

you can use BigInt in the datastage table definition to support oracle datatype integer, it will remove all of your warning messages.

Regards