In Star schema the dimensions can have attributes that may have low cardina

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

6 Answers
11578 Views
Accenture, IBM, TCS, I also Faced
E-Mail Answers

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

Explain what is a three tier data warehouse?

976

Explain what are the various reporting tools in the market?

983

What is the use of tabular model, tabular sql, tabular reference in real time application?

961

Explain what is the difference between a primary and secondary actor in use case modeling?

1069

How can you set the session management?

1123

How do we design a universe?

938

Explain what are components of reportnet?

975

Explain hybrid slowly changing dimension?

1006

Compare and contrast aggregates & indexes

3777

What is operational data store (ods)?

1020

What is MODEL is Data mining world?

2618

What is surrogate key? Where we use it? Explain with examples.

1027

What are the various file formats involved in reportnet?

982

How can you import tables from a database?

1086

Explain what are the various methods of getting incremental records or delta records from the source systems?

967