Number conversion
Posted: Wed Sep 30, 2009 11:09 am
Hi all,
Can any one help me out with how this can be achieved using Transformer.
I have the following input( Double= type)
1234.89
-1234.00
2345.67
in the output, i need to get the following (fixed length of width 12)
+00001234.89
-00001234.00
+00002345.67
I am using the target type as Decimal(10,2), the negative sign is coming but the positive sign is not (Datastage default for '+' numbers is blank)
Can anyone help me out
Thanks!
Marcus
M
Can any one help me out with how this can be achieved using Transformer.
I have the following input( Double= type)
1234.89
-1234.00
2345.67
in the output, i need to get the following (fixed length of width 12)
+00001234.89
-00001234.00
+00002345.67
I am using the target type as Decimal(10,2), the negative sign is coming but the positive sign is not (Datastage default for '+' numbers is blank)
Can anyone help me out
Thanks!
Marcus
M