Unmatched records issue

[reddy]

Hi Guys,

Could you please help on the following issue. while doing the look up, for the unmatched records in one of the column (ODBC stage timestamp data type) I am getting the ******************* value. But my target column is oracle databse timestamp.
I couldn't understand why I am getting ******************* value instead of null or zeros.

If i change my target data type to varchar then it is loading with ******************* value.

I appreciate your help

[BugFree]

19 * characters. Exact length of a timestamp field. Firstly, i am quite sure your column is a nullable "no" field. And secondly, you have given the value 19 "*" to substitute in case of a null in the field properties.