Jobin Joseph Veliyath

• May 30th, 2012

 

Surrogate Key is used in the place where the unique key is not there. Surrogate keys are mainly used for reporting for retrieving the data as fast as they can. The Index will be set in the surrogate Key.

djkool4u

 Profile Answers by djkool4u 

• Jul 11th, 2013

 

Is Slowly Changing Dimension (SCD) Implementation we use Surrogate key as the primary key is being duplicated for the sake of keeping history data for the records with the same pk.

Mallikarjuna_G

 Profile Answers by Mallikarjuna_G Questions by Mallikarjuna_G

• Aug 10th, 2013

 

In a typical data warehouse environment, we normally have a requirement to keep history. So, we would end up having multiple rows for a given Primary key. So, we define a new column that doesn't have a business meaning of its own but acts a Primary key in a dimension. If you have Surrogate Keys defined in each of your dimensions, then your fact table will have each of these keys from dimensions as foreign keys and measures.

Coming to usage of Surrogate keys in reporting - they are not specifically reported but, we build queries where the fact table is joined with each of these dimensions on these keys.