Page 1 of 1
DECIMAL TO DECIMAL CONVERSION REDUCTION IN SIZE
Posted: Mon Oct 18, 2004 10:34 pm
by npraveen
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.
Posted: Tue Oct 19, 2004 1:18 am
by ray.wurlod
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.
Posted: Mon Mar 20, 2006 11:12 am
by alisoviejo
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.
Posted: Mon Mar 20, 2006 12:29 pm
by ray.wurlod
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.