DSXchange

Thanks all for your prompt response. My second issue got resolved. I was using NullToZero(StringToDecimal(INPUT_COL)) which was giving me timezone error. Craig: My bad, I have Unix as my OS. Ray: For your question regarding "why?" - I don't want to complicate my job by introducing two tran...

Hi All, Converting StringToDecimal and back DecimalToString in a single transformer stage: I have a job where I need to perform data type conversion in a single transformer stage. I have a Varchar2(25) field which needs to be converted to Decimal (20,1) and then back to Varchar2(25).The challenge ov...