For me I had to uncheck the 'Keep NULLS' option to get the default value to be inserted!

Charles Mulwa

You need to use coalesce to specify what value gets returned by a query in case there is a null. You can stage the data after retrieval then manipulate the...