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

------------- How to identify the Revenue Column in Report?

1823


What are the batches and it’s details?

570


Can you define cube?

593


how u burst the reports? if u r bursted reports is not reached to destination how u identify???

10751


1. Explain your project.

1594






What is difference between page break and section report? What is main advantage datawarehousing over oracle?

607


how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

699


WHAT ARE THE DISTNICT VARIABLES?

1753


Can you define cognos powerplay?

637


1.WHAT IS XML SPECIFICATION WHAT IS PURPOSE,WHERE YOU ARE GOING TO USE.2 DIFFERENCE BETWEEN RENDER VARIABLE AND CONDITIONAL BLOCK.3.WHAT IS LINK AND SEGMENT.4.WHAT IS CONDITIONAL LAYOUT.5. DIFFERENCE BETWEEN DETAIL FILTER AND SUMMERY FILTER AND HOW YOU ARE GOING DEFINE IN SQL (DETAIL AND SUMMARY FILTER ).. WELL THESE QUESTION I BEEN FACED IN IBM COULD SOMEBODY GET SOLUTIONS PLZ..THANKS IN ADVANCE

1697


what is stitch query in reportnet?

626


Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days

3156


Can you define set to be cardinality?

591


What is called materialized view?

597


in u r data u having duplicates how to fetch the latest data in our report?

4617