Are you familiar with the Dynamic and the Static Cache?
When it comes to updating the master table, the dynamic cache can opt. Also, the users are free to use it for changing the dimensions. On the other side, the users can simply manage the flat files through the Static Cache.
It is possible to deploy both the Dynamic and the Static Cache at the same time depending on the task and the overall complexity of the final outcome.
