Answered Questions

  • Why should we use only a Re-usable sequence generator transformation inside a mapplet?

    Adil M

    • Jul 10th, 2007

    This is because we cannot use a Non Reusable Sequence Generator Transformation in a mapplet. Hence we must use a Re usable Sequence Generator. The fact that we reuse mapplets has no bearing over why we should use a reusable SG.

    madarapu

    • Jul 3rd, 2007

    Since mapplet is to reusability so if we include  a sequence generator inside a mapplet.the mapplet which we r going to reuse it for next time the sequence generator properties would be changed.so that we can not recommend it inside a mapplet which gives inproper result set.

  • 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 ...