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
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
What is model filter?
Can you define pivot?
What are the advantages of cognos?
What are the types of studio?
how you migrate reports to cognos 8 from previous versions?
What is the difference between Open Connection command ang Open Session Command?
What is Bitmap Index?
how u burst the reports? if u r bursted reports is not reached to destination how u identify???
What are the types of security?
How the Bursting happens in same report and how to Print the bursting Report?
Name the types of gateway?
Explain difference between powerplay transformer and power play reports?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?