Answered Questions

  • What are Dimensions and various types of Dimensions?

    set of level properties that describe a specific aspect of a business, used for analyzing the factual measures of one or more cubes, which use that dimension. Egs. Geography, time, customer and product.

    Star Read Best Answer

    Editorial / Best Answer

    ManishTewatia  

    • Member Since Jul-2010 | Jul 22nd, 2010


    What Md.Rehman is trying to say is catagorizing the SCD which are the Slowly Changing Dimensions which are used to maintain historical data.

    Dimension
    :A dimension is an organized hierarchy of categories, known as levels, that describes data in data warehouse fact tables

    The various types of dimensions are :

    1) Shared and Private Dimensions: Describes the basic differences between shared and private dimensions and their uses

    2) Regular Dimensions: Provides information about regular dimensions and their variations

    3) Parent-Child Dimensions: Describes the creation of parent-child dimensions and identifies their advantages and restrictions

    4) Data Mining Dimensions: Describes the creation of data mining dimensions and identifies advantages and restrictions to their use

    5) Virtual Dimensions:Describes the creation of virtual dimensions and their advantages and restrictions

    6) Dependent Dimensions: Describes the creation of dependent dimensions and identifies their advantages and restrictions

    7) Write-Enabled Dimensions: Describes the creation of write-enabled dimensions and identifies their advantages and restrictions

    VIKRAM KUMAR

    • Feb 28th, 2018

    Dimensions are of several types but we use few commonly which are, 1. Confirmed dim. dim. shared by all fact tables. ex- time dim. 2. Slow changing dim. it is of 3 types : SCD1. SCD2, SCD3., 3. Role ...