Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Data Warehouse General
  2. Suggest New Category

Hi,

Could any one tell me which schema (star and snow flake
schema) will take much space?

Thanks
S.A.K

Question Posted / pratap gangula

Answer Posted / pratap gangula

In Star schema the dimensions can have attributes that may have low cardinality which when separated out in other table will decrease the storage space.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is edw?

1270

If two relational tables are connected to sq trans, what are the possible errors it will be thrown?

1008

What is "method/1"?

1151

What are the differences between star and snowflake schema?

1178

How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.

1099

What is data warehosuing hierarchy?

1262

Do you view contain data?

1007

Difference between e-r modeling and dimentional modeling?

987

What we will do with the universe for faster process?

1028

What is application.cfm?

1114

What are the various tools? Explain name a few?

1022

Explain the importance of data warehouse?

1062

What are the types of SCD?

1281

What are fact, dimension, and measure?

1415

Explain er diagram?

1036