Types of fact table Fact tables are of two types CFT (Cumulative fact table) SFT (Snap Shot fact table) Cumulative fact table If we are loading the values into fact table based on time, then that is called cumulative fact table. Snap Shot fact table If we are loading the values based on client requirement, then that is called snap shot fact tables. Types of facts Fact : Fact is a numeric value, based on that numeric value; we are going to analyze data. There are three types of facts are there. They are as follows. Additive fact Semi additive fact Non additive fact Additive fact: - If fact values are coming from all dimensional tables, then such a fact is called additive fact. Semi additive fact: - If fact values are coming from few dimension tables, then that is called semi additive fact. Example: Transactions at bank (say if I drop deposit some money in my mom’s account, she only gets to know that amount is credited. She won’t know...