Option to prioritize table mappings

In the case where you have multiple staging/intermediate tables from different sources with the same structure/keys, it would be nice to have the option to prioritize (set an order of precedence) on the data warehouse table mappings based on exists/not exists logic on the primary key. Currently, this requires building an additional table or view to set the precedence when the same primary key values exist in multiple sources. When a data warehouse table has more than one mapping defined, it would be beneficial to have the option to execute the mapped transfers sequentially in the order of desired precedence.


Please sign in to leave a comment.