DataType Conversion

srivvds · Post by **srivvds** » Fri Nov 11, 2005 1:26 am

Hi,

I am trying to convert Datatype from Varchar which is in DataSet Stage to Decimal which is in OCI Stage for Sequence Number generation.........I tried StringToDecimal(Column) in Transformer and Column=Decimal_From_String(Column) in Modify Stage but I couldn't solve it.

Any suggestions from you?

Thanks,
RDSM.

ArndW · Post by **ArndW** » Fri Nov 11, 2005 2:55 am

The functions are the correct ones for that transformation. What did you try and what were your problems?

richdhan · Post by **richdhan** » Fri Nov 11, 2005 2:56 am

Hi,

Both the methods will work but what is it that you cannot solve. Pls give more info like the output that you are expecting and the actual input you had provided.

--Rich