Skip to main content

Posts

Showing posts with the label Fact Tables

Types of Dimensions ,Types of Facts and Features of Dimension and Fact table

Types of Dimensions A dimension table consists of the  attributes  about the  facts . Dimensions store the textual descriptions of the business. Without the dimensions,  we cannot measure the facts.  The different types of dimension tables are explained in detail below.   Conformed Dimension:  Conformed dimensions mean the exact same thing with every possible fact table to which they are joined. Eg: The date dimension table connected to the sales facts is identical to the date dimension connected to the inventory facts.   Junk Dimension:  A junk dimension is a collection of random transactional codes flags and/or text attributes that are unrelated to any particular dimension. The junk dimension is simply a structure that provides a convenient place to store the junk attributes.  Eg: Assume that we have a gender dimension and marital status dimension. In the fact table we need to maintain two keys referring to these...