Unmatched records issue
Posted: Tue Mar 11, 2008 9:50 pm
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
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