If it would be possible to somehow make the process of reading data from the source systems to exMonDM and then back into the DW more efficient
The current process is to:
1) Create a table in exMonDM
2) Create a data transfer to push the source data table to the exMonDM database
3) Create a merge script to merge the source data table into the table you've created
4) Attach the merge script to the data transfer task
One idea would be to be able to automatically create the merge script from the exMonDM destination table where you would select the source table and select what columns are the key columns and what columns to track changes on. This could be created as an action that could then be executed from the data warehousing tool or this is something that would be executed automatically when the source table is updated in the exMonDM database