Dylan's BI Study Notes

My notes about Business Intelligence, Data Warehousing, OLAP, and Master Data Management

Snow Flake Schema

Snow Flake is referring to a data model design for BI that in addition to the fact table to dimension table join, there is a join between a dimension table to another dimension table with the data at a higher level.

Snowflake in Oracle BI metadata

When we have a snow flake data design in the source data model or  the data warehouse design, we can use one LTS with multiple tables within the LTS.

LTS can make the snow flake join hidden from the users and the two tables having the snow flake join appears to users as a single dimension table in the logical layer.