1

I read a lot about data mart and know that data mart uses star and snowflake schema. But I want to know that what is normal form of Data Mart.

Manoj Kumar Dhakad
  • 1,862
  • 1
  • 12
  • 26

1 Answers1

1

No, a data warehouse is not normalized

A data warehouse uses dimensional design and should be highly denormalized to facilitate analysis

Your operational database (like for an e-commerce site) uses relational design and should be highly normalized to minimize update anomalies

Neil McGuigan
  • 46,580
  • 12
  • 123
  • 152