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 is the difference between querystudio in reportnet and cognos8
What is catalog and types of catalogs in cagonos and which is better?
How do we create row level security in cognos8?
What are all types of Batches?
is there any difference between operational database and data base?if yes what r they?
1.tyes of security in cognos?.how to use rank function? 2.what is content store? 3.what is content manager? 4.how 2 use rank function?
what is difference btw summary filter and detail filter, plz explain with example
10 Answers IBM, TCS,
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
wt is the OLAP Scrubbing in Framework manger & use? How can we developed a query items by using alredy existing query items?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
diff b/w layout calculation and query calculation
What is conditional Formatting?