Hi Swapy_1612!
A fact table, dimension table, and master table are all components of a data warehouse. Here's a brief explanation of each:
Fact Table: A fact table contains the data to be analyzed. It holds the quantitative or numerical data that represents business transactions or events.
Dimension Table: A dimension table stores descriptive information about the data in the fact table. It provides additional details and context for the measures in the fact table.
Master Table: The term "master table" is not commonly used in the context of data warehousing or business intelligence. It may refer to a central or authoritative table that contains comprehensive and accurate data for a specific entity or subject area.
In summary, fact tables contain the numerical data to be analyzed, dimension tables provide descriptive information and context for the analysis, while the term "master table" may refer to a comprehensive and authoritative table but is not commonly used in this context.
All the best,
Tony
.png "Former Employee"){kind=icon}
