Diff b/w surrogate Key and Primary Key?
Answers were Sorted based on User's Feedback
Answer / uma
Primary keys are used in OLTP whereas surrogate keys are used in OLAP schemas.PKs hold some business meaning whereas SKs does not hold.PKs contain both numeric as wellas non numeric values whereas SKs contain only simple numeric values.
| Is This Answer Correct ? | 7 Yes | 0 No |
Answer / krishna
surragate key is a system generated primary key.
| Is This Answer Correct ? | 4 Yes | 1 No |
is cognos 7 is better than cognos 8
How do you improve the performance of the Cognos Analytics report
What are all the types of indexes in Cognos?
What are the differences between cognos reportnet 1.1 report studio and cognos 8 report studio?
Write various indexes used in cognos?
What is architectue of Cognos 8
How to hide/unhide the prompts which are not used by unauthorized users?
what is your project workflow and your role in the project?
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?
What is difference between data mart and data warehouse?
How do we drill through from a powerplay cube to reportnet?\
What is use of Field Set present in toolbox?