Explain the fact table and the dimension table?



Explain the fact table and the dimension table?..

Answer / Suneel Kumar Sahu

In a data warehouse, a Fact Table stores measurable or quantifiable data about the business events, with each row representing an individual event. It contains numeric values and is connected to one or more Dimension Tables, which provide context and attributes for those facts. Dimension Tables, on the other hand, store descriptive information about the entities in the Fact Table, such as dates, categories, or locations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Tableau Interview Questions

Define aggregation and disaggregation of data in tableau.?

1 Answers  


Suppose my license expires these days, will users ready to read the dashboards or book that I revealed in server earlier?

1 Answers  


What is your work process?

1 Answers  


What is crosstab chart?

1 Answers  


What are the four different kinds of shelves in Tableau?

1 Answers  


How do I automate reports using tableau software?

1 Answers  


What is the difference between Tableau and Qlikview?

1 Answers  


How can you display top five and last five sales in the same view?

1 Answers  


What is story in tableau?

1 Answers  


What is the sort Of Measures?

1 Answers  


How to create cascading filters without a context filter?

1 Answers  


What are the differences between Tableau desktop and Tableau Server?

1 Answers  


Categories