what is an sid (surrogate key)?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

Mention the difference between ‘macros’ and ‘prompt’?

601


Tell me about Dnamic and Static Dashboards?

1860


What are the types of folder present in cognos?

632


explain how to create powerplay reports?

604


What is the difference between low affinity and high affinity connections?

547






------------------What is Inline Query?

1782


Can you explain the advantage of using shortcuts?

608


How to generate the Catalog in Cognos? Basically all post describing generating the Catalog from cognos impromptu . Is there any way to generate the Catalog using Cognos Administration or Framework Manager?

1538


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

537


Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?

642


what is the role of cognos comsultant?what actually it means?pls reply

1876


what is the diff. between a link n a union? what is a custom view? what is the use of unlocking a report ? plz answer to these

1593


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

1587


What are initial page components of Cognos connection?

604


What are the advantages of using cognos sql?

650