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 |
Hi,Can anyone tell me training centre for cognos in Mumbai?
What is the difference between group and associare?
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
How we check the errors before running the report?
For example I developed some reports on employee package now I have to develop same reports to another package.How can I change reports to another package?
Can we create a report in cognos BI without a Package? i.e. without framework manager? If so how? I have been asked this question twice..i think this feature is available in cognos 10 version..not very sure....Could anybody highlight?
I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
In Report page i have three types like (List,Cross tab,Chart), using Conditional Block i need only type of Report (Chart)at run time.How to do this I need The Complete Steps to do this?
What is the model filter?
how to handle multifact?
What is minimum version of internet explorer to run the Cognos report.