Answered Questions

  • What is surrogate key ? Where we use it explain with examples?

    Star Read Best Answer

    Editorial / Best Answer

    Answered by: saravanan

    • Dec 2nd, 2005

    Surrogate key is a unique identification key, it is like an artificial or alternative key to production key, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high


    • Oct 29th, 2017

    Surrogate key is system generated key. It is a column or set of columns declared as primary key instead of real of natural key.

    Anukul Thawarey

    • Aug 8th, 2017

    Just to add on to this point, we can also have date stamp as in the format (yyyymmdd) which is actually an 4 Byte unsigned integer to keep track of the historical data. This date stamp column can also be considered as an surrogate key.

  • Discuss which is better among incremental load, Normal Load and Bulk load

    Star Read Best Answer

    Editorial / Best Answer


    • Member Since Jan-2006 | Jan 29th, 2006

    if supported by the database  bulk load can do the loading faster than normal load.(incremental load concept is differnt dont merge with bulk load, mormal load)


    • Sep 14th, 2011

    It's totally depends upon the requirement. generally bulk load is faster caz it won't write the data to database logs so we can't do session recovery where as in normal load it is very slow comparing to bulk but the advantage is we can do session recovery..


    • Apr 12th, 2011

     Incremental load: Incremental means suppose today  we processed 100 records ,for tomorrow  run u need to extract  whatever the records inserted newly and  updated after ...

  • What is the maplet?

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


    • 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