Interview Questions

What are the types of Fact Tables? - ETL

ETL (extract, transform, and load) Testing Interview Questions


(Continued from previous question...)

45. What are the types of Fact Tables? - ETL

The types of Fact Tables are:
1. Cumulative Fact Table: This type of fact tables generally describes what was happened over the period of time. They contain additive facts.
2. Snapshot Fact Table: This type of fact table deals with the particular period of time. They contain non-additive and semi-additive facts.

(Continued on next question...)

Other Interview Questions