what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...
- 1 Answers
- 5250 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 is the importance of having monitor service in cognos?
What is the enterprise class platform architecture of cognos 8?
What is the difference between set functions and filter function in dimensional data?
What is difference between page break and section report?
where you can save the report net documentation in our local system?
What is the complex report you faced in real time?
Hi, I have Cognos 7.0 Impromptu reports and these reports have been created with the Mainframe datasource. Now the business needs these reports should be upgraded but with Oracle datasource. So what's the idea, first we should migrate these reports into ReportNet? then in that case what we will do with the Impromptu Catalog? Second, suppose we need to migrate these reports into Cognos 8 (may be 8.4) then how we will do that? do we need to create a FM Model for these reports. Please advice!
9. What was the most complex type of report you dealt with?
Explain what is the difference between microstrategy and cognos reporting tool?
What DB View and Bus View?
What are types of batch available in cognos?
I have a reports on cognos ep7series version3 with database SQl2000.Now i am migrating database SQL2000 to SQL2005.Then What happens to cognos reports and also there is reports cubes then how can i handle this problem please give me step by step solution b'coz i am new to cognos ep7series
What are all the advantages of Cognos?
Can you define cognos decision stream?
What are slice and dice?
