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 |
What are initial page components of Cognos connection?
What are cognos connection initial page components?
what is the difference between group span and level span
difference between drill through and master detail report?
What are the different uses of a repository manager?
What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.
how can create a report like if the salary>50,000 display balance,if salary<50,000 display green?
can any one explain about blue prints&performance tuning in cognos?
what do you mean by parallel execution of query?
What is the difference between a data mart and a data warehouse?
How can we find out cardinality between two tables?
Define the slice and dice?