What is snow flake scheme design in database?
Answer
A snowflake Schema in its simplest form is an arrangement of fact tables
and dimension tables. The fact table is usually at the center surrounded by the
dimension table. Normally in a snow flake schema the dimension tables are
further broken down into more dimension table.
E.g. Dimension tables include employee, projects and status. Status table can be
further broken into status_weekly, status_monthly.
|