• Home
  • sprajarajan Answers

Answered Questions

  • Sep 21 2004
    04:00 AM
    2263
    9

    what is a transforamation?

    It is a repostitory object that generates,modifies or passes data.

    sprajarajan

    • Aug 8th, 2008

    A TransFormation Is a Repository Object.That Generates,Modifies or Passes Data.The Designer Provides a Set of Transformations That perform Specific Functions.For Example An AGGREGATOR Transformation Performs Calculations On Groups Of Data.

    bibhu

    • Nov 10th, 2006

    Transformation is a repository object of converting a given input to desired output.It can generates,modifies and passes the data.

  • Sep 21 2004
    04:00 AM
    5922
    25

    What is the maplet?

    Maplet is a set of transformations that you build in the maplet designer and U can use in multiple mapings.

    sandeepbabu

    • Apr 21st, 2014

    Maplet is a resuable object,created with business rule using set of transformations and maplet is created with i/p maplet transformation and o/p tarnsformation. Maplet can be created without i/p maplet transformation.

    It can be divided into two type:

    1)active maplet
    2)Passive maplet

  • Sep 20 2004
    06:26 PM
    27481
    41

    What is a Source Qualifier?

    It represents all data queried from the source.

    Star Read Best Answer

    Editorial / Best Answer

    sprajarajan  

    • Member Since Mar-2008 | Aug 8th, 2008

    Source Qualifier Is the default Transformation.
    Through The source Qualifier Transformation Informatica Reads The Data.
    We can Filter The Data.
    We can sort the Data.
    Its also Used to Join Homogeneous Source systems.
    We can Join Any number of Sources in Singlae Source Qualifier.
    We Can't Join the Flatfiles In sourcequalifier Because Flatfiles Are Heterogeneous When we open the Flatfiles At sourcequalifier At the time All The options are Disabled.

    joyfun23

    • Jan 26th, 2010

    1. Source Qualifier is the most important transformation which convert the source data type in to compatible NATIVE datatype of a mapping.2. Without a SQ a mapping can not be created, after extractio...

  • Sep 20 2004
    04:00 AM
    15097
    87

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