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
What is defined as Query studio?
What is meant by Reportstudio shortcut?
What are all the types of gateway used in Cognos?
-----------------What is Direct and Conventional loading?
What is the model filter?
Define dimensions?
difference between impromptu and cognos8
tell me two or three issues from client side and how to solve those issues?
What is set to be Cognos configuration?
what is power prompt in cognos ep7series?what is the use of this?
What is main difference mapplets and mapping?
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
Please Answer this Questions: 1.In FWM We have to create Hierarchies, Condition is we don't know the correct levels in the Hierarchies, in this case how can we find out the levels (year->Quarters->month->day)in data? 2. In FWM Standalone Filter is for Reusable purpose & Embedded Filter we cant resuse.but is this possible to convert the Embedded filter to standalone filter? 3.What are the differences between Relational Database Model & Multi Dimensional Database? 4.In Drill Down/ Drill Up, How to specify the limits for example in a report there is 6 Drill down is possible, but i want only 3 Drill downs, the report should not allow 4 Th Drill Down.How to make this ? 4. What are the limitations in Select and Search Prompt ?
What is difference between page break and section report?
how to perform single sign in cognos by using url?