Snowflake Schema

In a snowflake schema implementation, OWB uses more than one table to store the dimension data. Separate database tables or views store the data pertaining to each level in the dimension.

Figure: Snowflake Schema Implementation of the Products Dimension displays the snowflake implementation of the PRODUCTS dimension. Each level in the dimension is mapped to a different table.