Datawarehouse is the storehouse or central repository for structured data. Data coming from various resources CRM, ERP, Billing, Supply chain, etc…., are first cleaned, transform, and then loaded into a storehouse called a data warehouse.

In order to store data in the data warehouse, we use a design pattern called Star Schema. Design patterns consist of facts & dimensions tables that resemble star.

Facts:

1) Facts are the numerical values, observations, and subject of analysis.

Example: temp, sales orders, exchange rates

Dimensions:

1) Dimensions are the textual values, and the context of analysis, contains most attributes.

Example: product, people, places & concepts

Measures:

1) Measures are the property on which min, max, avg, count, sum, etc… calculations can be made.

STAR-SCHEMA

In a star schema, facts and dimensions tables are linked with the help of primary and foreign keys of the tables.

Thank you for the read😊.Do clap if find it useful!!!!!

“Keep learning and keep sharing knowledge”

--

--

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store
Nidhi Gupta

Nidhi Gupta

490 Followers

Database Engineer 👨‍💻.Heading towards cloud technologies✌️.