I have data coming in from the text file as NULL.
The SQL field being loaded is a character field. I'd like to change that NULL to a space. I am doing it now with a SQL after but just wondered if there is a way to do it in the load.
"Advanced ETL Processor is superior software... I highly recommend this to anyone who is building datawarehouse. I would and I have recommended it to many colleagues and customers."