what is an sid (surrogate key)?
- 4 Answers
- 9127 Views
- IBM, I also Faced
- E-Mail Answers
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 are all the types of gateway used in Cognos?
what type of charts we create mostly in realtime? plz help
What is Performance Tunning Test?
How create measures and dimensions?
What is difference between primary key and unique key constraints?
what is a Galaxy Schema?
2. What functional area you worked on.
what is reprompt?
in u r data u having duplicates how to fetch the latest data in our report?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
How is cognos model organization works?
Hey Techies, Could you please tell me about query processing? and what is database only and what is Limited locale? brief plz..
Teradata 
