Hi,
I want to use mapping set to map several ODX tables with the same table structure to a single DW table.
The problem is that I also want to create additional “custom fields” in the DW table, and since these fields do not exist in any of the ODX tables, the mapping set excludes all the ODX tables and I am left with an empty DW table. Is there a work around to this? or am I perhaps doing something wrong?
This is my DW table:
The bolded fields with descriptions do not have mappings to them, they instead have custom transformations.
I have used “convert to mapping set” to get the mapping set, and then adjusted it so both tables match the mapping set rules.
As seen below, both tables are then excluded since neither have the custom fields.
Is it necessary that all fields have at least one mapping to them?
