DSXchange

are you using a transformer stage before you see the value '*******' in the target stage?
If yes then is there any implicit type conversion being done for that field?

rgds,
Nik

hi, It depends upon your business logic as what to default the NULLS to in decimals and date fields. We had faced a similar problem and had asked the business to define the defaults incase NULLS were encountered. Sometimes a NULL value in a decimal field is also correct data. you might default it to...

U did not respond. (U is the name of one of our posters. I understand that it is a fairly common Burmese name.) The second person personal pronoun in the nominative or accusative (objective) form in English is spelled "you". cheers Ray.. U didnt but you did ! :lol: anyways if someone want...

Just similar thing happened with me,
and I found out that it was a problem with the server system date that had been changed.
Once it was reverted to the correct date, Things worked fine.

The problem in this case is the NLS map defined in the stage property is taking the project default value. The default NLS for Teradata is ASCII. modify the NLS map setting in the stage property to ASCII After that search and edit the tera_cs.txt file (take a backup before) to add the following line...