Can any one explain about Core Dimension, Balanced Dimension, and Dirty Dimension?
Submitted by: AdministratorDirty Dimension is nothing but Junk Dimensions. Core Dimensions are dedicated for a fact table or Data mart. Conformed Dimensions are used across fact tables or Data marts.
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. |
