what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
- 1 Answers
- 5411 Views
- I also Faced
- E-Mail Answers
Answer Posted / g.v
Primary key as all of u know this is a unique key,surrogate
key is a non -intelligent key which is used to replace a
composite key
we are going for surrogate key bcz suppose a person is
living in one city and then moved to other and the person
id is a primarykey.we need to update the location then we
need to add the updated record but the primary key wont
accept to add the record again for this purpose we will go
for surrogate key
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
How to create a cube in Transformer? What is the process? Please mention process thank u
what are the special features in cognos reportnet?
What is a Transformer?
what is the procedure for scheduling conditional rendering?
WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?
What is defined as catalog and types of catalogs in Cognos?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
What is the model filter?
What is the use of powerhouse?
i was asked what are the caluclations done by you in your report? plz give reply
What is a dimension?
---------------Describe OLAP Reporting and RDBMS Reporting?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
Cleared COG-112 with 100% score today. What next certification should i go for?
What do you understand by the term 'aggregate advisor?'
