what is an sid (surrogate key)?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / madho
it's a duplicate key for primary key or unique key
when we need to maintain historical data instead of primary
key and unique key we use surrogate key...
| Is This Answer Correct ? | 5 Yes | 2 No |
Answer / bhaskar.nagi
It is a System Generated Key. It is act as a Primary Key.
| Is This Answer Correct ? | 1 Yes | 0 No |
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
HOW TO DEVELOPE THE DRILLTHROUGH REPORTS?
How can we create a dynamic column name in cognos?
In one of my report i have one data item sales_amount. If this report is run by one user from india so the sales_amount should be display in indian repees(Rs.) format, if USA user then in dollers($), if UK user then In Pounds.Hou can i achive this? Please answer me.
4 Answers Accenture, HCL, IBM,
What is the difference between low affinity and high affinity connections?
What is the use of powerplay web viewer in cognos?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
Types of Performance Tuning?
What is defined as Query studio?
----------------What is meant by DSS?
How to give a securites in object level&datalevel&pakege lavel in frame work manager?
what is the role of cognos comsultant?what actually it means?pls reply