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

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.