Mapping multiple (thousands) fields into NULL
Is there a way to change the mapping of multiple fields into NULL but not one by one?
I've been dealing with almost 4,000 fields to change all to NULL.
Dirk Venken replied
There are 2 ways to do this at mapping level:
1/. Select all fields in the target schema (use shift-click or right-click to do so), then right-click and select Properties... from the pop-up menu. Set Mapping to null.
2/. In the last Query transform before the target table: select all fields in the target schema (use shift-click or right-click to do so) and delete. Fields not included in the insert will get a null value by definition.