0 votes
in Informatica by
What is a Dimensional Model?

1 Answer

0 votes
by

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.
  2. Gallery Schema.
  3. A schema is a data model that consists of one or more tables.

Related questions

0 votes
asked Jul 19, 2023 in Deep Learning by SakshiSharma
+3 votes
asked Jan 21, 2021 in C Plus Plus by SakshiSharma
...