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 power play plug in?
Hi Cognos Folks, I have all cognos certification dumps. In fact i am certified in most of the dumps recently. I have cognos material, pdfs, user guides, documents along with dumps. If any one required cognos dumps, please drop me mail at cognos.biuser@gmail.com Thanks, Cognos bi user
Explain about core dimension,
What is Factless fact table? In which purpose we are using this in our DWH projects?Plz give me the proper answer. Thanks, Ramesh
What is the use of tabular model, tabular sql, tabular reference in real time application?
Explain Association algorithm in Data mining?
What is an IDQ file? What is the purpose of the IDQ file and what kindof information does it usualy hold? Can it be imported by informatica?
what is table partitioning? How it is useful to warehouse database?
What is cfapplication tag?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are cluster analysis in data warehousing?
What is the difference between snowflake and star schema?