adspace


  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 / kranthi.kunta

Answer Posted / kranthi.kunta

Star flake schema will take more space than snow flake
schema.
Snow flake schema approach increases the number of joins
and results poor performance in data retrieval. In few
organizations, they try to normalize the dimension tables
to save space.

keke...

Is This Answer Correct ?    3 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of Dataware Control?

1125

Explain have you ever been in a real dilemma at work? What did you do to get out of it?

1053

does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

6097

Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani

2355

Explain how to generate iqd file from framework manager?

1040