Why we implement sarrogate key in ETL Process?

mallikkd

 Profile Answers by mallikkd Questions by mallikkd

• Aug 14th, 2010

It is a unique primary key that is not derived from the data that it represents, therefore changes to the data will not change the primary key.In star schema it is used to join Dimension and Fact tables.

ramadevi1111

 Profile Answers by ramadevi1111 Questions by ramadevi1111

• Apr 16th, 2009

To generate sequence numberGenerally it starts with 0neBasically it is to differentiate the primary key

Answer Question  Select Best Answer