what is an sid (surrogate key)?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Can you explain new content durability?

558


what are the limitations of cognos reportnet? What are the enhancements in reportnet ?

606


How to generate cubes in cognos?

556


What is the difference between the content store and content manager?

556


How create measures and demensions?

591






what is the difference between list report and crosstab report?

696


how u will design the report if the objects are available

2312


I have 7500 rows. I need all rows in single reports. Which type of prompt we have used retrieving all rows and show in a report? We have dynamical queries q1, q2, q3, q4, q5. If customer selects the particular, query that only show in execution report. In case it may more then one, how do you execute the particular query item in report page? What are the difference bt OLDP and OLAP?

1669


Can you define bitmap index?

580


Why cognos decision stream is used?

624


What do you mean by Drill down and Drill Up?

557


-----------------What is Determination Model?

1679


what do u mean by bridge group? where we r using this one?

1538


What is meant by junk dimension?

554


What is the complex report you faced in real time?

1713