It might be more efficient to do the update in your staging or output table instead of as part of the transformation. You'll need to test to find out which way is best.

Aside from that, my advice is not to do this. NULL means unknown, so to use it to represent a known absence of a value is something of an abuse.

John