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 |
How to pass multiple values from picklist prompt to sub report filter?
---------------Tell me about DWH Concepts?
what is materialised view? why we use it in data warehousing?
what is prompt variable
what are the joins present in reportnet?which is most widely used?
4 Answers Covansys, IBM, Satyam,
I have two date promts which optional. by defalt it will be checked.i want to unchek that date prompts.How to uncheck the date prompts in cognos
how u migrate reports to cognos 8 from previous versions
Can we install Cognos 8.4 on Windows Vista...Please let me know....Thanks!!!
Explain about scorecarding?
can you tell me what are the dimension tables are used in project
How do we drill through from a powerplay cube to reportnet?\
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?