What are the differences between star and snowflake schema?
Submitted by: AdministratorStar schema: A single fact table with N number of DimensionSnowflake schema: Any dimensions with extended dimensions are known as snowflake schema.
Submitted by: Administrator
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
| ☺ | What is the difference between aggregate table and materialized view? |
| ☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
| ☺ | What is the advantages data mining over traditional approaches? |
| ☺ | What are data validation strategies for data mart validation after loading process? |
| ☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
| ☺ | Warehouse Assistant Interview Questions. |
| ☺ | Ab Initio Interview Questions. |
| ☺ | Data Stage Interview Questions. |
| ☺ | ColdFusion Interview Questions. |
| ☺ | Data Warehouse Supervisor Interview Questions. |
