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
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What actually a project contains?
Can you define drill across?
which type of project we r going to snowflake schema
How to create a cube in Transformer? What is the process? Please mention process thank u
What are the different kinds of panes included in cognos?
What are query items?
How security is concerned with Reportnet? Explain its implementing steps.
please please give me some banking calculations in framework manager.
i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..
What is meant by Reportstudio shortcut?
what are the names of the reports that you prepared?
What is the difference between a cascading report and drill through the report?
my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...
What do you understand by user class in cognos?