Interview Questions

What is factless fact schema? - ETL

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


(Continued from previous question...)

16. What is factless fact schema? - ETL

- Factless fact is a fact table without measures
- It can view the number of occurring events

Example :
- A number of accidents occurred in a month.
- The no. gives a basic count, and this would not allow for making business intelligence. Hence this is not measurable.
- The accidents count is statistical information, and can not be controlled directly.

(Continued on next question...)

Other Interview Questions