DSXchange

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.

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

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