alpinestart
Technical User
I'm faced with a situation that is really a fundametal difference is thinking. Our CIO feels a data warehouse is for directional reporting, trending, high level view into the business. Many users expect it to be a detail view at the transactional level and expect it to tie to the penny to source G/L systems.
Of course the CIO "accepts" a certain level of variability in the data (<@1% is fine with him).
So my question is - is it realistic to build a warehouse to match source system to the penny? Should we strive for this?
I can see arguments for both sides and would like to hear others people's opinions and experiences.
Of note: this is NOT a financial, gl data warehouse per say. it mainly a sales dw.
thanks
Of course the CIO "accepts" a certain level of variability in the data (<@1% is fine with him).
So my question is - is it realistic to build a warehouse to match source system to the penny? Should we strive for this?
I can see arguments for both sides and would like to hear others people's opinions and experiences.
Of note: this is NOT a financial, gl data warehouse per say. it mainly a sales dw.
thanks