Explain the fact table and the dimension table?

devquora
devquora

Posted On: Feb 22, 2018

 

Fact table:
They are the measurable quantities or the numeric metrics of the data which can be analyzed by dimension table.
Facts are stored in the fact table contain foreign keys that uniquely refers to the associated dimension tables.
The fact table is compatible to store the data at the atomic level and thus, it allows a large number of records to be inserted at once.
For instance, a sales category fact table can have a product key, customer key, promotion key referring to a specific event.
Dimension table:
They are the descriptive attribute values for various dimensions of each attribute which define multiple characteristics.
A dimension table referring a product key from the fact table can consist of a product name, product type, color, size, and description.

    Related Questions

    Please Login or Register to leave a response.

    Related Questions

    Tableau interview questions

    What is Tableau ?

    Tableau is a data visualization tool that allows the user to develop an interactive and apt visualization in the form o..

    Tableau interview questions

    Define different parameters in Tableau and their working?

    The Tableau parameters are dynamic variables or dynamic values that replace the constant values in data evaluation and ..

    Tableau interview questions

    Distinguish between parameters and filters in Tableau?

    The radical difference actually lies in the application. The parameters allow users to insert the values, which can be ..