I'd like to ask a basic question.
Source table has 30 fields. Target table has 40 fields, 10 are not mapped and null is not allowed in target. I want to populate the 10 fields with constant value ''. How can I do it in query(transfer)?