My job is aborting because of this error generated by aggregator stage: Value treated as NULL
Attempt to convert String value "26.50" to Decimal type unsuccessful
The think is the data looks like a decimal and the data type is also decimal.
Does anything need to be change on NLS ?
No, this has nothing to do with NLS. Perhaps there are "hidden" characters in the string and I seem to recall that spaces cause issues as well. Do the explicit conversion in a modify or transform stage and you can also implement the IsValid() function to check on validity.
I was thinking that it has to do with NLS cause when the decimal value is with coma then it works.
Again the issue is within the aggregator, I need to set the decimal value in aggregator with dot and not coma.
I did change the NLS many times but still ask for coma as decimal.
The "," comma is the decimal separator in several NLS locales so you are correct and I was wrong - it is likely to do with NLS after all. What Locale do you have set - in German, for example, the default decimal separator is the "," character. Also, in the "edit row" attributes for the column in question, do you have "decimal separator" set - if not, try putting in a decimal point.
The actual character set is not important - it is the NLS Locale which affects such things as date & time format, decimal separators, currency and collating order.
Unfortunately, when I change those NLS settigns in US -ENGLISH , still the decimal is not recognized. And There is no NLS tab within the aggregator stage. I'm going to check if there is anything to do on administrator ...