General Datawarehousing Question:

Download Job Interview Questions and Answers PDF

What is a level of Granularity of a fact table?

General Datawarehousing Interview Question
General Datawarehousing Interview Question

Answer:

Level of granularity means level of detail that you put into the fact table in a data warehouse. For example: Based on design you can decide to put the sales data in each transaction. Now, level of granularity would mean what detail are you willing to put for each transactional fact. Product sales with respect to each minute or you want to aggregate it upto minute and put that data.

Download General Datawarehousing Interview Questions And Answers PDF

Previous QuestionNext Question
Explain me What are Data Marts?Explain me what is VLDB?