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 |
Where the applications and where ware house management system is used?
Explain what is the difference between view filter and report filter?
What is the difference between power center & power mart?
How can you set the session management?
difference between For each and for all
Explain the difference between keylokup and joiner?
What is DTM session?
What is MDX?
In datastage can ve find the job based on source table name ??
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
For faster process, what we will do with the universe?
What is the difference between Datawarehouse and OLAP?