Table Types Flashcards

1
Q

Track and analyse the full history of changes in your data

A

Temporal

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

Node and edge tables

A

SQL Graph

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

Degenerate dimension

A

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

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Contains relatively static data which can change slowly and unpredictably

A

SCD

How well did you know this?
1
Not at all
2
3
4
5
Perfectly