Apologies for this duplicate post. I would like to use this forum for this query.
Many Thanks for your response. Myself coming from traditional data warehouse developing background, believe in building ODS>>DWH>>Report>>Cubes. But due to short time to deliver few Summarized reports I was trying to draw a solution on paper to build cubes. In longer term do you think the traditional approach gives more benefits and is a right approach?
Using the cube approach, I'm not sure if I can consolidate data from heterogeneous sources and build cubes.
Lets say Employee dimension. If I have 3 sources having 3 Employee tables, when building a cube can I build one customer dimension? However, if I take traditional approach I can achieve this.