Interested to Buy Any Domain ? << Click Here >> for more details...
what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
- 1 Answers
- 6228 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
What are the advantages of shortcuts?
Explain about scorecarding?
What errors and types of errors you faced in Cognos ReportNet?
What are the considerations regarding performance kept in mind while setting up cognos?
What are the message flows?
is cognos 7 is better than cognos 8
-----------------What is Direct and Conventional loading?
What is the deployment requirements used in cognos?
Write various indexes used in cognos?
what are slowly changing dimensions? Why we are used scd?
What is defined as Query studio?
Define olap designer?
What do you understand by the cognos?
What is Online View?
How do you improve the performance of the Cognos Analytics report
