Interested to Buy Any Domain ? << Click Here >> for more details...
When should you use a STAR and when a SNOW-FLAKE schema?
- 6 Answers
- 49578 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / shivaleela
STAR SCHEMA:-if PERFORMANCE is the priority than go for
star schema,since here dimension tables are DE-NORMALIZED
SNOW-FLAKE SCHEMA:-if MEMORY SPACE is the priority than go
for snoflake schema,since here dimension tables are
NORMALIZED
| Is This Answer Correct ? | 36 Yes | 5 No |
Post New Answer View All Answers
explain about balanced dimension,
What are the data types present in bo? What happens if we implement view in the designer n report?
Explain the data type of the surrogate key?
Why should you put your data warehouse on a different system than your oltp system?
Explain what is the main difference between inmon and kimball philosophies of data warehousing?
Explain what are the basic needs to join two sources in a source qualifier?
Explain what is real time data-warehousing?
What are the main steps to build the data warehouse?
Difference between cold fusion mx 6 and cold fusion mx 7?
What is a staging area? Do we need it? What is the purpose of a staging area?
What is pre-emptive and non-pre-emptive?
Explain what is full load & incremental or refresh load?
What a static and local variable?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is a data warehousing?
