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 |
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
1. Differences between Merge and Union In Cognos?
What is the advantage of using shortcuts?
How can we convert imr report into Impromptu web report?
can reportnet supports cubes???
What is Report item
what is the procedure for scheduling conditional rendering?
WHAT SHOULD BE DONE WHEN A REPORT RUNNING TIME WILL TAKE LONG TIME IN CONGNOS?
2 Answers ABC Infotech, Virtusa,
Where do you edit cognos sql in report studio?
It is possible with out same Queries(both Reports) we can build the drilltrough between them? and how?
how many numbers of cubes can we create on a single model? How can we navigate between those cubes?
What is Metrics designer?