ComeçarComece de graça

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

Ver curso

Exercício interativo prático

Transforme a teoria em ação com um de nossos exercícios interativos

Começar o exercício