Archives of the TeradataForum

Message Posted: Mon, 19 Mar 2007 @ 20:43:59 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Ramu

I have one type of solution for your problem .

You need some transformation in your source try to represent a charater value for null s like '*' or what ever .

Ex,

if it is oracle source

     select NVL(IN_a,'*') from table ;

and in your layout look for '*' and convert into null

     .FIELD IN_a        * VARCHAR(1) NULLIF   IN_a = '*'

then it will take care of nulls

Enjoy ,

Ganesh Babu
Teradata certified Master .

	<Prev	Next>		<<First	<Prev	Next>	Last>>