DECIMAL TO DECIMAL CONVERSION REDUCTION IN SIZE

npraveen · Post by **npraveen** » Mon Oct 18, 2004 10:34 pm

My incoming datatype is Decimal (38,10) which has to be mapped to Decimal (18,0) field. The incoming data will never have decimals. How do I got about reducing the size. The target database is teradata.

ray.wurlod · Post by **ray.wurlod** » Tue Oct 19, 2004 1:18 am

Try performing simple arithmetic (adding zero is good) in a Transformer stage. DataStage should look after the metadata transition across the Transformer stage.
Beware, however, that any source number with more than eighteen significant digits will fail to load into the target.

alisoviejo · Post by **alisoviejo** » Mon Mar 20, 2006 11:12 am

Hi Ray,

I guess, when we are reading decimal values from teradata, the 0s are truncated
ex 1.5 instead of 1.50

Is there any way we can preserve the 0s.

ray.wurlod · Post by **ray.wurlod** » Mon Mar 20, 2006 12:29 pm

Open the row (Edit Row in the Columns grid) and set the Decimal Type sub-property. Click on Help to learn more about what this does. Beware that the data browser (View Data) may add leading zeroes to the display of decimal fields whether or not they are actually there in the data.