Table Types

Question 1

Track and analyse the full history of changes in your data

Answer 1

Temporal

Question 2

Node and edge tables

Answer 2

SQL Graph

Question 3

Degenerate dimension

Answer 3

Data dimension stored in fact table, rather than separate dimension table

Question 4

Contains relatively static data which can change slowly and unpredictably

Answer 4

SCD