Hi,
I'm evaluating the use of SDDM for data design of a data warehouse. My DWH will be build using 3-layer architecture with: Operational Data Store, Enterprise data warehouse layer, Datamart layer.
First two layers are relational models: ods is just a load off all sources; edwh comprises both master data and subject area in a relational model. Datamart is the top layer made in form of multidimensional model.
My question is if it's better to use a single 'design' of SDDM where I create multiple relational model and multidimensional or a different design for any layer.
Thanks
Pilot