Sreedhar Lokaray

• Nov 3rd, 2011

Let me just give the Data quality problems. If I explain it will go page by page. 1. Dummy values in source system fields. 2. Absence of data in source system fields. 3. Multipurpose fields. 4. Crypt...

Faizal

• Aug 30th, 2011

You have to test all the transformations in your ETL and write negative scenarios.

Answer Question  Select Best Answer

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

Answer Question  Select Best Answer

sivaranjith

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

Answer Question  Select Best Answer