How to calculate fact table granularity?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Data Warehouse General Interview Questions

What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?

0 Answers  


What are the stages of datawarehousing?

0 Answers  


What are data modeling and data mining? Where it will be used?

0 Answers  


What is the main difference between inmon and kimball philosophies of data warehousing?

0 Answers  


How to eliminate duplicate rows from flat file?

0 Answers  






Explain what are non-additive facts in detail?

0 Answers  


If your client approaches you and says that he wants to create a Datawarehouse, and provides just the info regarding his source systems. What are all the neccessary actions one is supposed to take/understand and get back with a comprehensive document which convinces the client to proceed with the DW initiative. What are all the documents we need to provide the client?

1 Answers   CSC,


Explain bus schema?

0 Answers  


What are algorithms provided by Microsoft in SQL Server?

0 Answers  


Explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  


Explain degenerate dimension table?

0 Answers  


where exactly in dataware house a confirmed dimension can be created

4 Answers   Deloitte,


Categories