It is also known as fact constellation schema। It is a combination of star schema and snow flack schema. As discussed earlier it consists of conformed dimensions.
The dimensions in this schema are segregated into independent dimensions based on the levels of hierarchy. For example, if geography has four levels of hierarchy like region, country, state and city; constellation schema would have four dimensions instead of one.
As we see in the two star schemas as below, the two fact tables, sales table and purchase table are now sharing both the 'product' and 'time' dimension tables. Therefore we decide to choose Galaxy Schema as the model for our data warehouse, which is displayed as follow:
Star schema for sales
As per galaxy schema:
The active data warehouse service provider helped me in empowering the various organizations and the management of data. It was fortunate for me that I had chosen this blog to get the best results related to the proper data warehouse. The platform and the solutions shared in this article helped me in the appropriate data managing strategy and you need to read more about the planning schemes offered by this blog.
ReplyDelete