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

P.Manideep

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

Improve Answer

Read Best Answer

Editorial / Best Answer

gazulas  

 Profile Answers by gazulas Questions by gazulas

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

ram_infa

 Profile Answers by ram_infa Questions by ram_infa

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

vikota

 Profile Answers by vikota Questions by vikota

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

Improve Answer

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

abhishek_upadhyay

 Profile Answers by abhishek_upadhyay Questions by abhishek_upadhyay

• Sep 18th, 2008

Basically mapplet is a subset of the mapping in which we can have the information of the each dimension keys by keeping the different mappings created individually. If we want a series of dimension keys in the final fact table we will use mapping designer.

Answer Question  Select Best Answer