Can anyone tell me if you should store combin
ed data from sources in the data vault
? I'm torn between the options. If we decide to store combin
ed data, and the business wants to change requirements for storing data, wouldn't this create problems? On the other hand, the business rules may never change and this may never be an issue. Then again, in the satellite
, we have a number of fields for one table. Some of the fields must have a certain amount of integration for the analysis. If we don't combin
e the source information, we'll have to create a table with a number of fields.
I'm wavering back and forth and would really appreciate your perspectives and advice. What would be the best solution keeping in mind that the business rules could or could not change in the future?