what is an sid (surrogate key)?

Answers were Sorted based on User's Feedback



what is an sid (surrogate key)?..

Answer / arkchowdary

Surrogate Key----------------- It is a System Generated Key
they are not derived from any Data Sources.

Surrogate Key----------------- It is a Unique Identifier.

Surrogate Key----------------- It is used to identify each
Row of a table uniqely.

Surrogate Key---------------- It also helps to track Slowly
Changing Dimensions.

Surrogate Key---------------- It replaces all Natural Keys.

Is This Answer Correct ?    9 Yes 0 No

what is an sid (surrogate key)?..

Answer / madho

it's a duplicate key for primary key or unique key

when we need to maintain historical data instead of primary
key and unique key we use surrogate key...

Is This Answer Correct ?    5 Yes 2 No

what is an sid (surrogate key)?..

Answer / bhaskar.nagi

It is a System Generated Key. It is act as a Primary Key.

Is This Answer Correct ?    1 Yes 0 No

what is an sid (surrogate key)?..

Answer / zams

Surrogate key is artificial key

Is This Answer Correct ?    2 Yes 5 No

Post New Answer

More Cognos Interview Questions

What is the function of cognos dispatcher?

0 Answers  


10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,


How can we migrate from Businees Objects reports to Cognos 8.x??

1 Answers  


Why do we create shortcuts in framework manager

4 Answers  


What is slowely changing dimensions?why we are used SCD?

2 Answers  






What is the difference between a cascading report and drill through the report?

0 Answers  


Anybody sugest me either url address or website for cirtification in Cognos from cognos.com !

3 Answers  


What is the difference between static and dynamic conditions?

0 Answers  


What is difference between content store and content manager?

0 Answers  


Hi..I have COG-112(Report Author),COG-122(Admin),COG-132(Meta data modelling). I took test end of Sep '09.I got 100% wcore with these dumps. If any body need then mail me on kris.bi121@gmail.com

2 Answers  


What are user classes?

1 Answers   HCL,


what is session parameters? what is use?

1 Answers   HCL, Satyam,


Categories