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 |
what is mean by cognos powerhouse?
What you mean by drill across and what is the difference between drill through, drill across?
example for generated prompt
What is the difference between low affinity and high affinity connections?
im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?
How to identify in report that is apply as a detail or summary filter?By looking the report have to identify the report has applied as detail or summary filter to that report?
-------------Diff b/w Union and Unionall?
architecture of cognos8
How can you schedule the report that it displays a day old data. (My answer was to create a view, but the lady wanted some other method).
what are the components in the cognos connection page consists (eg: my folder, public folder,directions, schedule management tool etc.....)
Diff b/w surrogate Key and Primary Key?
Can i apply drill through on master detail relationship report?