Interview Questions

What are Fact Tables? - ETL

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

(Continued from previous question...)

43. What are Fact Tables? - ETL

A Fact Table is a table that contains summarized numerical (facts) and historical data. This Fact Table has a foreign key-primary key relation with a dimension table. The Fact Table maintains the information in 3rd normal form.
A star schema is defined is defined as a logical database design in which there will be a centrally located fact table which is surrounded by at least one or more dimension tables. This design is best suited for Data Warehouse or Data Mart.

(Continued on next question...)

Other Interview Questions