Archives of the TeradataForum

Message Posted: Mon, 31 Oct 2005 @ 17:54:31 GMT

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

Hi all

I have a question relating to fastexport and null handling.

We have a series of fastexports which we use to export data which is then mloaded into the EDW targets.

Many of the columns have nulls. The problem I am having is that these nulls are not being correctly loaded into the targets and are loaded as blanks. I would have assumed that using the fastload format that these nulls would have been correctly handled. However, using case in the mload doesn't want to work correctly either

If I try

     .FIELD  SerialNumber    * char(10)

     case when :serialnumber  = '' then null else :serialnumber end

blanks are inserted

     case when :serialnumber  = '          ' then null else :serialnumber end
     (note 10 spaces between quotes)

also results in blanks

I suppose I could do a case statement in the original exports and use that value for the multiload case, but that seems to be a bit self defeating.

Am I missing something?

Thanks

Simon

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