master data list synchronization between models


Master data lists needs often be synchronized between the Data Hub and spoke models. At the moment we do this as follows (for incremental loads):

In the spoke model:

1. Set the property 'in use' of all list items on FALSE

2. Load in the data from Data Hub to your spoke model (incl. the TRUE flag for 'in use' property).

3. Delete all items that are not 'in use'

There are more flavors to think of for deletion of unused items. This is just an example, however it always requires 3 steps.


It would be nice to have a native (sub)list synchronization functionality between models. This will save a lot of model building time, result in a leaner model as it requires 1 step in stead of 3 every time and might be less error prone.

With one singe action you would be able to synchronize 2 lists based on their code.

7 votes

New · Last Updated


Get Started with Idea Exchange

See our Submission Guidelines and Idea Evaluation Criteria, then start posting your own ideas and showing support for others!