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 to identify the Revenue Column in Report?
Hi.. friends, dis Bhaskar p.if any of u having realtime scenerios.. plz send to me.. my mailid s bhaskarparitala.rao@gmail.com send ASAP.. waiting for reply..
Can you explain new content durability?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
how to connect datamarts
what do u mean by bridge group? where we r using this one?
9. What was the most complex type of report you dealt with?
Can you define a query subject?
What junk dimension contains?
----------------------What are the User Securities?
What is the use of powerplay web viewer in cognos?
-------------What is Coditional Prompting?
What is the model filter?
What errors and types of errors you faced in Cognos ReportNet?
What is the difference between drill through, drill across?