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
- 11337 Views
- Accenture, IBM, TCS, I also Faced
- E-Mail Answers
Answer Posted / laz
The answer is STAR SCHEMA . As, the data stored in
diamensional tables of the star schema is denormalized
hence it increases the space needed for storage of data.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a functional dependency f said to be minimal?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
How much data hold in one universe.
What is data cleaning? How can we do that?
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 different types of schemas used in data warehousing?
What are the different types of segments?
What is cfapplication tag?
Explain what is a three tier data warehouse?
does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com
Where the applications and where ware house management system is used?
What needs to be done while starting the database?
What are necessary tasks to install reportnet software?
Explain is fact table?
What is a staging area? Do we need it? What is the purpose of a staging area?
