what is an sid (surrogate key)?

Answers were Sorted based on User's Feedback



what is an sid (surrogate key)?..

Answer / m m naidu

surrogate key: It has system generated artificial key
values, which allows to maintain historical records in the
data warehouse more effectively.

Is This Answer Correct ?    2 Yes 1 No

what is an sid (surrogate key)?..

Answer / rajdeep chatterjee

Surrogate key is an artificial key which is a system
generated one. It can be created from Oracle using
sequence, can also be created using ETL tools. It is the
unique key is dimension tables. The purpose of using
Surrogate key is to reduce the dependency from underlying
database.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

whis meant by Thumbnails on cagnos?

2 Answers  


What is the difference between Open Connection command ang Open Session Command?

0 Answers  


What is the enterprise class platform architecture of cognos 8?

0 Answers  


What is meant by Reportstudio shortcut?

0 Answers  


what is the automation tool used for data warehouse testing???

3 Answers   Covansys, IBM, Wipro,






What are the steps to import the two data sources in framework manager?

0 Answers  


What is Star schema group?

1 Answers   IBM,


advantages of cascade prompt ???

3 Answers   iFlex,


what are the features in cognos8ui

0 Answers   HSBC,


Can you define a catalog and types of catalogs in cognos?

0 Answers  


hi this is bhaskar iam working in Tcs u want any real time faqs send me your qs i will ans that qs ok this is my id bhaskarparitala.rao@gmail.com

0 Answers  


Define dimensions?

0 Answers  


Categories