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
Explain what is the difference between native sql and cognos sql?
What is the use of report studio?
Can you define pivot?
How create measures and demensions?
A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.
difference between impromptu and cognos8
What is Online View?
What are the advantages of cognos?
What is the use of cognos decision stream?
Define query studio?
How to generate cubes in cognos?
What are the components of the report studio?
what is the procedure for scheduling conditional rendering?
What are the advantages of using cognos sql?
What is a Query Subject?