How the Space will treat from dataset to Teradata

[irajasekharhexa]

Hi,

In one of the Job, For a particulor column of the type varchar in the dataset is having a value as blank but while loading the teradata the same column defined with the data type decimal. Since it is space/blank at the dataset it is populated as Blank at the teradata.


Now again from the teradata(Decimal) i am trying to populate the same blank value data to dataset(varchar) it is populating as '?' value.

Coluld any body suggest how can we handle this to avoid '?' values at the teradata while populating?

We can change the datatype in Teradata as varchar. But client is not favour of it.

Thanks in advance.