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 are the methods by which it non-durable model could be changed into the durable model?
what is stitch query in reportnet?
Can you define a query subject?
Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
Which studio is used to create reports?
Can you explain model durability?
What is main advantage datawarehousing over oracle?
actually 2 members working in same module.at a time is possible to work on same module? i add some tables,another person also add some tables how the synchronization betn the two in same module? pls ans me and expain to me.....
how to merge 2 crosstabs thans
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!
Give the advantages of cognos?
What is the use of powerhouse?
What is meant by alternate drill down with ex?