Hanu

• Jun 8th, 2006

 

HI,

 We use keys to provide relationships between the entities(Tables). By using primary and foreign key relationship, we can maintain integrity of the data.

The natural key is the one coming from the OLTP system.

The surrogate key is the artificial key which we are going to create in the target DW. We can use thease surrogate keys insted of using natural key. In the SCD2 scenarions surrogate keys play a major role

Cheers,

Hanu.

sekhu_da

 Profile Answers by sekhu_da Questions by sekhu_da

• Nov 14th, 2006

 

natural key :- seq no system assigned ..

skey :- user assigend ! u can start with any number like 100,10001,2002..

veer.dwh

 Profile Answers by veer.dwh Questions by veer.dwh

• Oct 1st, 2009

 

Natural key is nothing but primary key, it uses to identify a record uniquly.

Surrogate key is to identify a entity uniquly.

Regards,
Veeru.