Interested to Buy Any Domain ? << Click Here >> for more details...
Hi,
Could any one tell me which schema (star and snow flake
schema) will take much space?
Thanks
S.A.K
- 6 Answers
- 11338 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
What is the differences between star and snowflake schemas?
What are the various methods of getting incremental records or delta records from the source systems?
Explain which columns go to the fact table and which columns go the dimension table?
What is scd1 , scd2 , scd3?
Explain how to get the first 100 rows from the flat file into the target?
Explain what is the difference between datawarehouse and bi?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain what is batch and describe about types of batches?
Explain multivalued dependency?
Explain the difference between oltp and olap?
What is data stream and data adaopter. Is it same are different? Explain?
Explain the main difference between inmon and kimball philosophies of data warehousing?
What are the data types present in bo? What happens if we implement view in the designer n report?
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.
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
