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 meaning by Master detailed relationship ? please explain one example

4 Answers  


Can we test the report other than manual testing?

0 Answers  


how you create security to cubes ?????

4 Answers   iFlex, iGate,


Where do you edit cognos sql in report studio?

3 Answers   HCL,


what is the difference between native sql and cognos sql?

0 Answers  






-------------------What is StarShema?

1 Answers   Cap Gemini,


Which one is better among Value and select & search prompts,in terms of performance?

2 Answers   L&T,


Can you define drill across?

0 Answers  


What is meant by report studio short cut?

2 Answers  


hi cognos Experts what are the enhancements in cognos 10 than cognos 8.4?Pls Ans Me........

1 Answers  


hi frnds any body have cognos projects plz send me two(or)three projects to my mail adress ramureddy.reddy4@gmail.com.

0 Answers  


1. Can we import the cube into FWM? If yes how & what is the necessity to import it? 2. What is the use of TABULAR OBJECTS? Repeated Question

2 Answers  


Categories