Dimension Table: Dimension table is one that describe the business entities of an enterprise, represented as hierarchical, categorical information such as…