Trim with DecimalToString

ArndW · Post by **ArndW** » Tue Feb 05, 2008 7:36 am

A Decimal column cannot/does not have leading zeroes. Could it be that your input is coming from a text file and is a string? In that case just one StringToDecimal() call is necessary.

sumesh.abraham · Post by **sumesh.abraham** » Tue Feb 05, 2008 8:09 am

Thanks for the reply. You are right;the input comes from a file and in the sequential file's column definition I've mentioned it as Varchar 20, 4 and in the immediate transformer I'm mapping it where the column is Decimal 20,4 which is the expected format for the target Oracle table.
The data is 89 in the sequential file and since the column definition in the transformer is Decimal 20,4;the output link from the transformer will have will be having zeros preceding it. How can I solve this.

ArndW · Post by **ArndW** » Tue Feb 05, 2008 8:36 am

Take things step by step. If you do your StringToDecimal conversion and write the resultant decimal column to a PEEK stage, are your leading zeroes gone?

ray.wurlod · Post by **ray.wurlod** » Tue Feb 05, 2008 4:32 pm

Decimal numbers are always displayed by the data browser and by Peek with leading and trailing zeroes. This mechanism allows you to verify that precision and scale are being accurately handled. Internally, of course, decimal numbers are represented as binary - just a pattern of bits.