Data granularity in a data warehouse?

1 answer

Answer

1187019

2026-04-26 03:10

+ Follow

Granularity refers to the level of detail of the data stored fact tables in a data warehouse. High granularity refers to data that is at or near the transaction level. Data that is at the transaction level is usually referred to as atomic level data. Low granularity refers to data that is summarized or aggregated, usually from the atomic level data. Summarized data can be lightly summarized as in daily or weekly summaries or highly summarized data such as yearly averages and totals.

ReportLike(0ShareFavorite

Copyright © 2026 eLLeNow.com All Rights Reserved.