what is the different between primarykey and surrogated
key.. why we are going for surrogatekey...



what is the different between primarykey and surrogated key.. why we are going for surrogatekey.....

Answer / 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

More Cognos Interview Questions

What is the use of cognos decision stream?

0 Answers  


What is the size of the cube?

0 Answers  


--------------How to do Report Testing in Reports?

1 Answers   IBM,


Name the types of report?

0 Answers  


How to apply securities for reports in cognos connection?

0 Answers   TCS,






What is Outerjoin?

2 Answers  


How to connect three fact tables?

11 Answers   L&T, TCS,


Hi I have Most updated Cognos dumps like COG-112(ReportAuthor),COG-122(Admin),COG-132(Meta Data Modeller). 100%score Gurantee. If anyone intrested mail me on kris.bi121@gmail.com

7 Answers  


can any one pls send me the project flow at the time of interview

0 Answers  


If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?

2 Answers   IBM, Polaris,


It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha

0 Answers  


What do you understand by the term 'aggregate advisor?'

0 Answers  


Categories