can a field be defined Decimal(2,2) in the database?

[smohd1338]

Hi,

I have this wierd requirement, i dont know if the table was designed wrong, but my process is aborting due to this reason.

I have field as Integer(2), from flat file and that is staraight drop in to table into a filed which defined as decimal(2,2), in transformer i directly gave as decimal(2,2) and is failing with many of these warnings

the source decimal has even precision, but non-zero in the leading nybble, or is too large for the destination decimal..Record dropped.

on investigating i discovered its decimal(2,2) and i changed it ti decimal(4,2) and ran target as dataset, its working . So can there be decimal(2,2) or should i ask my DBA to change it to (4,2)

[ray.wurlod]

Decimal(2,2) is not possible. Precision must be at least one greater than scale. So, yes, request the DBA to make the change.

[smohd1338]

Thanks a lot ray