Submitted Questions

  • What is data loading? Explain full refresh loading.

    satwant singh

    • Nov 29th, 2011

    Full Load is the entire data dump load taking place the very first time. Gradually to synchronize the target data with source data, there are further 2 techniques:- Refresh load - Where the existing...

    Sreedhar Lokaray

    • Nov 3rd, 2011

    In simple words, after transforming the data it is loaded into the DWH. Two distinct groups of tasks form the data loading function. When you complete the design and construction of the DWH and go liv...

  • When do we need surrogate key in data warehouse implementation?


    • Mar 25th, 2019

    Surrogate key is used in Datawarehousing concept for SCD-2 implementation and there are history records stored for a particular record we cant use primary key as integrity violation will occur for the same record so in that case Surrogate key is used for historical and new records.

    Sreedhar Lokaray

    • Nov 2nd, 2011

    By definition, surrogate key is a system generated key. This key is used as Primary key in the Dimensions. Why? There are generally two principles to be applied when choosing Primary keys for the Dim...