what is an sid (surrogate key)?
Answers were Sorted based on User's Feedback
Answer / m m naidu
surrogate key: It has system generated artificial key
values, which allows to maintain historical records in the
data warehouse more effectively.
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / rajdeep chatterjee
Surrogate key is an artificial key which is a system
generated one. It can be created from Oracle using
sequence, can also be created using ETL tools. It is the
unique key is dimension tables. The purpose of using
Surrogate key is to reduce the dependency from underlying
database.
| Is This Answer Correct ? | 0 Yes | 0 No |
can we put more measure on cross tab? If so how many? How this affect the aggregation?
How to pass multiple values from picklist prompt to sub report filter?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance
how to perform back drill through in cognos 8 what is the use of it
Can you define cognos powerplay?
What is set to be Cognos configuration?
Define datastores in cognos?
These are the questions asking in many interviews, so pls help me,,, How did you get requirements from the client? How did you send reports to the client? How did you interact with your client? I mean through e- mail or phone or in any other way?
how to get the all values from a prompt using 'ALL' use and display value in prompt
What are the types of security?
what are the dimensions that you have in your current project?list them?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..