Schema is collection of database object, example - (table,index,view etc).
Most of the data warehouse use dimensional modelling.
Types of schema are
1 . Start Schema
2. Snow Flake schema
3. Star Flake Schema
4. Galaxy Schema
5. Bus Schema
Most of the data warehouse use dimensional modelling.
Types of schema are
1 . Start Schema
2. Snow Flake schema
3. Star Flake Schema
4. Galaxy Schema
5. Bus Schema
Comments
Post a Comment