kamal_ece (11/21/2012)
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.
Under the traditional DW approach, your ETL would bring the three sources into a common table and transform the source data so that you have common dimension table.
If you build your cube straight from the relational source data, you should be able to create a SELECT or a View that either JOINs or UNIONs your three data sources into one for an employee dimension.
Again the caveat that I've only built cubes against a dimensional model DW.
Good luck,
Rob