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 |
Este exercício faz parte do curso
Data Warehousing Concepts
Exercício interativo prático
Transforme a teoria em ação com um de nossos exercícios interativos
