Tuesday, June 14, 2011

What are the different schemas available for Data warehouse?

Data warehouse can be created two types of schema 1) Snowflake 2) Star Schema. The mostly star schema is used to create a data warehouse as fact is the centre table and it’s surrounded by different dimensions. I.e. many dimensions are attached to different fact tables.

Snowflake is a linear representation kind of thing.

1 comment:

  1. Hillco Fastener Warehouse is a full-service fastener warehouse specializing in automotive and industrial applications with tens of thousands of items in stock. zombie survival warehouse

    ReplyDelete