Saturday, 5 August 2017

Schema in data warehouse - SAP HANA

Database uses relational model to store data. However, Data Warehouse use Schemas that join dimensions and fact tables to meet business logic. There are three types of Schemas used in a Data Warehouse −

1. Star Schema

2. Snowflakes Schema

3. Galaxy Schema

No comments:

Post a Comment