What Does Level Of Granularity Of A Fact Table Signify?

1.	What Does Level Of Granularity Of A Fact Table Signify?
Answer» In simple terms, LEVEL of granularity defines the extent of detail. As an example, let US look at GEOGRAPHICAL level of granularity. We MAY analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET. In simple terms, level of granularity defines the extent of detail. As an example, let us look at geographical level of granularity. We may analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET.

Answer»

In simple terms, LEVEL of granularity defines the extent of detail. As an example, let US look at GEOGRAPHICAL level of granularity. We MAY analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET.

In simple terms, level of granularity defines the extent of detail. As an example, let us look at geographical level of granularity. We may analyze data at the levels of COUNTRY, REGION, TERRITORY, CITY and STREET. In this case, we say the highest level of granularity is STREET.

Discussion

No Comment Found

Related InterviewSolutions

Analysis In Business Objects?
Who Launches The Supervisor Product In Business Objects For First Time?
Multi Pass Sql:
Explain How To Mine An Olap Cube.
Differentiate Between Data Mining And Data Warehousing.
How Can You Access Your Repository With Different User Profiles?
What Is The Test Methodology For Testing Bo Universes?
When Is The Repository Created?
Can We Have Multiple Domains?
How Do You Restrict Access To Rows Of A Database?