Not able to handle Null
Posted: Tue Nov 27, 2012 3:34 am
Hi All ,
I have job which has Teradata as source and Oracle as target .
Some columns are coming as null, and as per the req if the column has null need to replace with 4 space .
But I am unable to handle the nulls coming from source with the help of isnull .
Is there any way to know whether the column has special characters / and ascii values .
Tried with the below commands , but both the command's didnt work
1: CONVERT(Char(0),' ',In.TextColumn)
2:if IsNull(TcpIn.OR) then space(20) else TcpIn.OR
Please help .
I have job which has Teradata as source and Oracle as target .
Some columns are coming as null, and as per the req if the column has null need to replace with 4 space .
But I am unable to handle the nulls coming from source with the help of isnull .
Is there any way to know whether the column has special characters / and ascii values .
Tried with the below commands , but both the command's didnt work
1: CONVERT(Char(0),' ',In.TextColumn)
2:if IsNull(TcpIn.OR) then space(20) else TcpIn.OR
Please help .