Please help me with details. Here is what i have gathered about creating a dw solution.
1.So, during staging i should denormalize the OLTP, get it into one or two tables and then create cubes from it.... where is the logic of using star and snowflake here?? sorry i have got myself confused. Thanks
2.Create separate views that de-normalize a certain reporting area into something similar/close to a data mart and then use it to source the cube???? Thanks
View Complete Post