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 |
Can you define confirmed dimension?
-----------------What is Determination Model?
What are all the components of Report Studio?
1. Explain your project.
what are summary filters? grouped filters?
if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used in report, what is the sql code? give me example?
What is the deployment requirements used in cognos?
10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list Rank Running-count
What is the difference between a data mart and a data warehouse?
What is a dashboard in Cognos Report Studio and how do we creae it
Hi, How the relations will be exists in DMR models if u have any idea please explain me
How will you migrate your reports to QA environment?