Archives of the TeradataForum
Message Posted: Mon, 31 Oct 2005 @ 17:54:31 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|