what is a ER Modeling techniques IN DATA WAREHOUSE?

ER Modeling is nothing but entity relationship modeling. in this model always call table as entities and it may be secondĀ  normal form (or) 3rd normal form (or) in between 2nd and 3rd normal form

Dimensional Modeling:

In this model tables called as dimensions (or) fact tables. It can be subdivided into three schemas.

  1. Star Schema
  2. Snow Flake Schema
  3. Multi Star Schema (or) Hybrid (or) Galaxy
Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.