Explain about core dimension, balanced dimension, and dirty dimension?
- 1 Answers
- 1103 Views
- I also Faced
- E-Mail Answers
Answer / Shailendra Kumar Paswan
In Data Warehouse (DWH) terminology, the core dimensions are the central aspects of a business that provide context to the data being analyzed. Balanced dimensions are attributes that have roughly equal numbers of occurrences for each possible value. Dirty dimensions are those with values that change frequently, which can cause performance issues in a DWH.
| Is This Answer Correct ? | 0 Yes | 0 No |
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
What are the possible data marts in retail sales?
What is data analytics in simple terms?
I need to set predefined condition. How I do this?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what is the data type of the surrogate key?
Explain what are the various reporting tools in the market?
What are steps we have to follow in designing the userfriendly universe?
What is the goal of optimizer?
What is critical column?
Explain what are fact, dimension, and measure?
Explain the structure of cold fusion?
Teradata 
