In Data warehousing, dimension table contains the textual or descriptive attribute of the data.
For example, Customer dimension will contain details about customer’s name,address,phone number etc.
Dimensions are used to slice and dice the data i.e. filter and group the data.Dimension table also help you by looking at data with“By”attribute i.e. say if the Total sales of the company is $1 Million then using Customer dimension you can look at the Total sales “By” Customer or “By” Time. A dimension table has a primary key column also called Dimension ID/Dim Id that uniquely identifies each dimension row. The dimension table is associated with a fact table using this key.
What is a Fact Table
Fact Table contains the measurable attribute of the data. It contains measurable data that can be analyzed by Dimension tables. Fact tables contain the foreign keys of the associated Dimension tables.