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 |
This exercise is part of the course
Data Warehousing Concepts
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
