Interested to Buy Any Domain ? << Click Here >> for more details...
Which one among Star and snowflake schemas will occupy more
space?
- 1 Answers
- 8285 Views
- Barclays, I also Faced
- E-Mail Answers
Answer / kiran
Star Schema will occupy more space since the tables are in
demoralized form and will have many historical records with
redundant information on some columns of the table. Hence
require more storage space.
| Is This Answer Correct ? | 25 Yes | 6 No |
How can we load the time dimension?
Explain some of modeling tools available in the market?
What are target types on the server?
What is called data cleaning?
Explain what is full load & incremental or refresh load?
what role views play in dimensional modeling?
Explain what are the steps to build the data warehouse?
Select * from emp,dept,loc where emp.deptno left outer join dept.deptno and dept.locno=loc.locno. No need to consider the syntax but is it possible to have left outer join and equi join in the same SQL like this ? can we have right outer join and left outer join in the same SQL ---
1 Answers Principal Finance, PT Metalogix Infolink Persada,
What are the difference between snow flake and star schema?
What are the key features of chameleon that separates it from other algorithms?
What is the difference between Oracle Express and Oracle Discoverer?
What is pre-emptive and non-pre-emptive?
Teradata 
