Which one among Star and snowflake schemas will occupy more
space?
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 |
What is Bulk Insert?
What is data type of the surrogate key?
How to know the time taken for particular report execution?
I know of using applysimple, but there are other ways too?
Is there any rownum object from which we can do this?
Explain what are the different types of data warehousing?
What is analytical or analytic mean?
Explain what is the limit to the number of sources and targets you can have in a mapping?
What is conformed dimension?
What are target types on the server?
Explain what is difference between query studio and report studio?
Code the tables statement for a single-level (most common) frequency?