Sollicitatievraag bij Agile Analytics Group
Explain the Fact and Dimension table with an example?
Antwoord op sollicitatievraag
Anoniem
17 mrt 2022
Dimension table will have primary key and most probably the text data where as fact table will have foreign key and all the numerical data Example:customer sales where customer basic information is in dimension and total sales profits numerical calculation will be in fact table