Answered Questions

  • how many types of dimensions are available in informatica?

    Santosh

    • Dec 26th, 2011

    In Informatica 4 types of dimensions are available, these are 1) Degenerate dimensions 2) Junk dimesnsions ( a dimension which contains the less numbers of cordinality vales are less number of ind...

    suren

    • Nov 22nd, 2011

    Hi Guys, Please don't answer wrong answers the above mentioned are Schema. , the dimension are discussed bellow. 1.Junk Dimension:Contains miscellaneous data such as flags and indicator 2.Degener...

  • 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

    • Mar 1st, 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 ...