When a table in MDW has multiple tables under Mapping (especially fact tables), but not all key fields are in all DSA tables, the default key should be set to value -1. In the current situation we have to add all missing key fields to the table in DSA and map them to MDW accordingly.
MDW tables are in Simple Mode to reduce execution time. Disabling Simple Mode and setting a default value to each key field will work here, but that increases the time to populate the table significantly. Technically speaking, Default Value is a table constraint and not a transformation, which should make it possible to implement it on tables in Simple Mode as well.
