What is data sparsity and how it effect on aggregation?
Submitted by: AdministratorData sparsity is term used for how much data we have for a particular dimension/entity of the model.
It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combination do not have any factual data then creating space to store those aggregations will be a waste as a result, the database will become huge.
Submitted by: Administrator
It affects aggregation depending on how deep the combination of members of the sparse dimension make up. If the combination is a lot and those combination do not have any factual data then creating space to store those aggregations will be a waste as a result, the database will become huge.
Submitted by: Administrator
Read Online Data Modeling Job Interview Questions And Answers
Top Data Modeling Questions
| ☺ | What is ERD? |
| ☺ | Why are recursive relationships are bad? How do you resolve them? |
| ☺ | What is second normal form? |
| ☺ | What is third normal form? |
| ☺ | What is an artificial (derived) primary key? When should it be used? |
Top Databases Programming Categories
| ☺ | RDBMS Interview Questions. |
| ☺ | SQL Interview Questions. |
| ☺ | SSRS Interview Questions. |
| ☺ | Database Administrator (DBA) Interview Questions. |
| ☺ | Sybase Interview Questions. |
