DSXchange

in your example the negation mark (-) is at the end of the string. Try flipping it to the front of the string, or just remove it and add if after conversion via a mathematical function Hi Stefan Thanks for your suggestion. I worked on that and got the solution. I have used some transformation for c...

you need to trim your input string and/or remove/change any unwanted characters.... Maybe your decimal point is invalid for example.... I understand that. i have tried for those options. But the problem is with negative values. positive values are loading properly. When a negative number is encount...

ray.wurlod wrote:Arnd meant that you should try Decimal[18,3] ...

By changing to Decimal[18,3], The output is nothing new than before except with some more zeros to match the length.
Negative values are simply loaded as 000000000000000.000.

I'm not at a terminal with the docs right now, but could it be that 13 and 3 means total width of 13, of which 3 are decimals? What happens if you try 18.3 ? ... "18.3" is loading as "0000000018.300". But I have tried it with sequential file stage used as both source and Target....

I'm not at a terminal with the docs right now, but could it be that 13 and 3 means total width of 13, of which 3 are decimals? What happens if you try 18.3 ? ... "18.3" is loading as "0000000018.300". But I have tried it with sequential file stage used as both source and Target....

How did you declare the numeric column data type? What happens when your source data is just a smaller number, i.e. "12.34"? ... The data type for the column is Numeric, length 13 and scale 3. There is a value "0.533" in the source and the corresponding value of the target is &q...

ray.wurlod wrote:Show the syntax you used with StringToDecimal(). ...

StringToDecimal(ext_s_e_b_item.SYSTEM_CALCULATED_OPENING_BALANCE)
mapped to output column SYSTEM_CALCULATED_BALANCE

Welcome aboard. Please explain your job design in more detail. In particular, are you applying any transformation to this field? If not, you probably need to investigate a function such as String ... Hi Ray Thanks for ur response. Actually no transformation is applied to the field. It's just a dire...

I am mapping a MS SQL database column with NVarChar datatype of length 17 to a MS SQL database column of datatype Numeric of length13 and scale 3 simply using a transformer stage. Source columns have some negative values. But in the target those -ve values are not coming. for example: Source column ...