Provide an action to update records using the default value instead of error or fail table action
The dictionary comparer and the table designer should do the following, if I introduce a new field with a default value and a null constraint:
1. Create field
2. Set default value property
3. Upate existing records to the default value
4. Set the can_be_null property to false
This workflow would be much better then what is happing now, because at the moment existing rows are thrown into the fail table.