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 / 9885657928

Answer Posted / 9885657928

Snow flake schema
why because a denormalized dimentional table splitted into
one or more tables which results in normalization of
dimentions.It hempers the Query performance due to more
number of joins.

Is This Answer Correct ?    0 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain how to generate iqd file from framework manager?

1040

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