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
how to perform single sign in cognos by using url?
Define the cognos reporting tool?
How to apply securities for reports in cognos connection?
faq's on cognos
i have taken quantity on ANx-axis & months on y-axis(months r not in oreder )when i run the reoprt i need months in proper order .how can i do this ?
Can you define dimension?
what is online view?
what is catalog and types of catalogs in cagnos and which is better?
Define dimensions?
Explain what is the difference between microstrategy and cognos reporting tool?
What is the advantage of using shortcuts?
I have ten columns that needs to be totalled... but some columns are empty...how do i get sum all the columns even if sum are empty? Can i get a total of the rows instead of columns? if yes, what is the function to be used?
What is the difference between ‘macro’ and ‘prompt?
What is called Cognos powerplay?
how to explain tne project at the time of interview? where to start and how to end? plz explain in detail thax in advance