what is the Surrogate key?and wt is the diff between Primary key and Surrogate

what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key?

Question Posted / ravis190784

2 Answers
7521 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?..

Answer / rajesh s. chandan

Unique identitiy key is generated during data load process
(ETL) in the datawarehouse system is called as Surrogate
key.
It is mainly used to update slowing changing dimesion
attribute data and also it removes dependencies on key
originating in different data sources.

Primary key is uniquely identified each record in a table
with no null values.

Is This Answer Correct ?

11 Yes

0 No

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?..

Answer / jayaraj

Primary key is a type of key where the data inside the
column should be unique and should not be null.we generally
use the primary key to access any of the rows of a table by
using the primary key column.when a table don't have a
primary key then we assign a primary key to the table which
is known as surrogate key for accessing any row of the
table. means the key will act like a primary key for the
table.

Is This Answer Correct ?

4 Yes

16 No

Post New Answer