what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
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
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
How we check the errors before running the report?
how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..
----------------Describe DWH Architecture?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
----------------Diff b/w Dimensional modeling and Relational modeling?
Can you explain a cognos controller?
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
Hi all... how can we publish packages using bmp scripts to Path:Public Folder Packages Folder
What are the advantages of cognos?
-----------Diff b/w OLAP and RDBMS?
Please explain the different stages in creating a report in cognos report net?
Can you define cognos powerplay?
What are the types of studio present in Cognos?
what are the special features in cognos reportnet?