can a field be defined Decimal(2,2) in the database?
Posted: Fri Mar 01, 2013 7:16 pm
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)
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)