Which Case you will go for star schema and snow flake schema

In your project Which Case you will go for star schema designing and which Case you will go for snow flake schema designing?

Questions by Aloka   answers by Aloka

Showing Answers 1 - 6 of 6 Answers

Ram

  • Jun 30th, 2016
 

Star schema --> Fact table is connect with different Dimension tables.
Snowflake schema --> Fact table is connect with different dimension tables. And dimension table/tables refer to another dimensional table.
Thanks !

  Was this answer useful?  Yes

Purba

  • Jul 4th, 2016
 

Snowflake schema is used for dimension Analysis. Eg: How many online accounts does an advertiser have.

Star schema is used for metric analysis. Eg: What is the revenue of a customer.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions