what is an sid (surrogate key)?
Answers were Sorted based on User's Feedback
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 |
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 |
whis meant by Thumbnails on cagnos?
What is the difference between Open Connection command ang Open Session Command?
What is the enterprise class platform architecture of cognos 8?
What is meant by Reportstudio shortcut?
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?
What is Star schema group?
advantages of cascade prompt ???
what are the features in cognos8ui
Can you define a catalog and types of catalogs in cognos?
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
Define dimensions?