What do you understand by Granularity in a table?

1.	What do you understand by Granularity in a table?
Answer» Granularity in a table represents the level of information stored in the table. High granularity of data means that data is at or near the transaction level, which has more detail. Low granularity means that data has low level of information. A fact table is usually designed at a low level of Granularity. This means that we need to find the lowest level of information that can store in a fact table. In date dimension the Granularity level could be year, month, quarter, period, week, and day.

Answer»

Granularity in a table represents the level of information stored in the table. High granularity of data means that data is at or near the transaction level, which has more detail. Low granularity means that data has low level of information.

A fact table is usually designed at a low level of Granularity. This means that we need to find the lowest level of information that can store in a fact table.

In date dimension the Granularity level could be year, month, quarter, period, week, and day.

Discussion

No Comment Found

Related InterviewSolutions

What are the different ways of assigning permissions to OBIEE repository?
Is it possible to create outer join in Physical layer?
When you have Tables T1 and T2 which are not joined, what will happen in BMM layer?
What is the difference between OBIEE 10g and OBIEE 11g administration?
What are different Application roles in BI system?
What is OBIEE Security? How do you define a Security policy in OBIEE system?
What do you understand by Data Level Security and Object Level Security?
What do you understand by connection pool and how many connection pools did you have in your last project?
What is the use of Column Prompts? Where they are used?
What are Inline prompts?