Interview Questions

What are the types of Facts? - ETL

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


(Continued from previous question...)

44. What are the types of Facts? - ETL

The types of Facts are as follows.
1. Additive Facts: A Fact which can be summed up for any of the dimension available in the fact table.
2. Semi-Additive Facts: A Fact which can be summed up to a few dimensions and not for all dimensions available in the fact table.
3. Non-Additive Fact: A Fact which cannot be summed up for any of the dimensions available in the fact table.

(Continued on next question...)

Other Interview Questions