Data Architect Question:

Tell me what is a fact & a fact table?

Data Architect Interview Question
Data Architect Interview Question

Answer:

Facts represent quantitative data. For example – net amount due is a fact. A fact table contains numerical data and foreign keys from related dimensional tables.


Previous QuestionNext Question
What are conformed dimensions?Tell me the physical data model?