Fact or dimension?
Below are the column names for two tables taken from the snowflake schema proposed by Tsvetanka Georgieva-Trifonova et al. to analyze academic bibliographic data. Your goal is to select the statement below that correctly identifies tables A and B as fact or dimension tables and the reason why.
| Table A | Table B |
|---|---|
| InstitutionID | PaperID |
| InstitutionName | JournalID |
| City | ProceedingsID |
| Country | InstitiutionID |
| PublisherID | |
| CountOfAuthorID | |
| CountOfPapers | |
| CountOfCitations |
Deze oefening maakt deel uit van de cursus
Data Warehousing Concepts
Praktische interactieve oefening
Zet theorie om in actie met een van onze interactieve oefeningen.
Begin met trainen