4.Explain Snowflkeschema ?
- 6 Answers
- 9503 Views
- EDS, HCL, IBM, iFlex, TCS, I also Faced
- E-Mail Answers
Answer Posted / sudheer.r
snowflake schema is centrally located fact table .and
surrounded by normalized dimension tables..
in snowflake compare to dimensions and ffact table
dimensions are small.dimensions are more compare to ster
chema .. snow flake shema very dificult to understand ...
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the different types of data warehouses?
How many types of facts and what are they?
Explain what is the difference between powerplay transformer and power play reports?
What are the tools available for etl?
What is normalization, first normal form, second normal form, third normal form?
Explain can a dimension table contains numeric values?
Can you pass sql queries in filter transformation?
What is surrogate key? Where we use it? Explain with examples.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
What is surrogate key? Where we use it explain with example?
What is a real-time data warehouse?
Explain difference between view and materialized view?
Name a few sectors which use data warehousing?
Explain what is data validation strategies for data mart validation after loading process?
What is the difference between static cache and dynamic cache?
