What Is Data Sparsity And How It Effect On Aggregation?

1.	What Is Data Sparsity And How It Effect On Aggregation?
Answer» Data 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. Data 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.

Answer»

Data 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.

Data 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.

Discussion

No Comment Found

Related InterviewSolutions

What Is Second Normal Form?
What Is An Artificial (derived) Primary Key? When Should It Be Used?
Is This Statement True Or False? All Databases Must Be In Third Normal Form?
Why Are Recursive Relationships Are Bad? How Do You Resolve Them?
What Is Third Normal Form?
What Is Erd?
When Should You Consider Denormalization?
What Is The Difference Between Hashed File Stage And Sequential File Stage In Relates To Datastage Server?
What Is Data Sparsity And How It Effect On Aggregation?
What Is The Difference Between Star Flake And Snow Flake Schema?