Diff b/w surrogate Key and Primary Key?
Answer Posted / 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 |
Post New Answer View All Answers
in u r data u having duplicates how to fetch the latest data in our report?
How to test a cube?
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
--------------Explain Table of contents?
What are query items?
What is a Transformer?
What is meant by Reportstudio shortcut?
How can I test reports in cagonos?
which type of project we r going to snowflake schema
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
What is the function of cognos dispatcher?
Explain what is the difference between native sql and cognos sql?
What is the deployment requirements used in cognos?
What is an olap designer?
What are the different uses of a repository manager?