Sign in to confirm you’re not a bot
This helps protect our community. Learn more

Types of Fact Tables in Data Warehouse | Transaction, Periodic and Accumulating

aroundBI
12.7K subscribers
91K views 7 years ago
Welcome to aroundbi. In this tutorial, We will understand different types of fact tables – transaction fact, Periodic snapshot fact and Accumulating snapshot fact table – based on individual requirements, we create and use these different fact tables in warehouse schema. We will go through a comparative study to evaluate which fact table type is better in what scenario. ...more
...more
Types of Fact Tables in Data Warehouse | Transaction, Periodic and Accumulating
1.3KLikes
91,611Views
2017Dec 17
Welcome to aroundbi. In this tutorial, We will understand different types of fact tables – transaction fact, Periodic snapshot fact and Accumulating snapshot fact table – based on individual requirements, we create and use these different fact tables in warehouse schema. We will go through a comparative study to evaluate which fact table type is better in what scenario.

aroundBI

12.7K subscribers