what is a Star Schema IN DATA WAREHOUSE?

A fact table surrounded by dimensions is called start schema. it looks like start

In a start schema if there is only one fact table then it is called simple start schema.

In a start schema if there are more than one fact table then it is called complex start schema

Sales Fact table:

Sale_id

Customer_id

Product_id

Account_id

Time_id

Promotion_id

Sales_per_day

Profit_per_day

 

Account Dimension:

Account_id

Account_type

Account_holder_name

Account_open_date

Account_nominee

Account_open_balence

 

Pramotion:

Promotion_id

Promotion_type

Promotion_date

Pramotion_designation

Pramotion_Area

Product:

Product_id

Product_name

Product_type

Product_desc

Product_version

Product_stratdate

Product_expdate

Product_maxprice

Product_wholeprice

 

Customer:

Cust_id

Cust_name

Cust_type

Cust_address

Cust_phone

Cust_nationality

Cust_gender

Cust_father_name

Cust_middle_name

 

Time:

Time_id

Time_zone

Time_format

Month_day

Week_day

Year_day

Week_Year

Related Posts Plugin for WordPress, Blogger...

Be the first to comment

Leave a Reply

Your email address will not be published.


*