Implementation of Star Schema in SQL SERVER

Published: 28 December 2020
on channel: Data Science Center
9,278
44

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.

==================


Watch video Implementation of Star Schema in SQL SERVER online, duration hours minute second in high quality that is uploaded to the channel Data Science Center 28 December 2020. Share the link to the video on social media so that your subscribers and friends will also watch this video. This video clip has been viewed 9,278 times and liked it 44 visitors.