How to calculate fact table granularity?
No Answer is Posted For this Question
Be the First to Post Answer
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
What are the stages of datawarehousing?
What are data modeling and data mining? Where it will be used?
What is the main difference between inmon and kimball philosophies of data warehousing?
How to eliminate duplicate rows from flat file?
Explain what are non-additive facts in detail?
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?
Explain bus schema?
What are algorithms provided by Microsoft in SQL Server?
Explain about core dimension, balanced dimension, and dirty dimension?
Explain degenerate dimension table?
where exactly in dataware house a confirmed dimension can be created