Implementation of Star Schema in SQL SERVER
Implementation of Star Schema in SQL SERVER
In dimensional model, the fact table are in the middle and the dimension tables arranged around the fact table.
Each of the dimension tables has a direct relationship with the fact table in the middle.
Such an arrangement in the dimensional model looks like a star formation, with the fact table at the core of the star and the dimension tables along the spikes of the star. The dimensional model is therefore called a STAR schema.
==================
