Question

What is a Dimensional Model?

Answer 1

Data Modeling:

1. It is a process of designing the database by fulfilling business requirements specifications.
2. A Data Modeler (or) Database Architect Designs the warehouse Database using a GUI based data modeling tool called “Erwin”.
3. ERWin is a data modeling tool from Computer Associates (A).
4. Dimensional modeling consists of the following types of schemas designed for Datawarehouse:

Star Schema.

1. Snowflake Schema.
3. Gallery Schema.
5. A schema is a data model that consists of one or more tables.