Diff b/w surrogate Key and Primary Key?
- 2 Answers
- 7813 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 |
What is the difference between ‘macro’ and ‘prompt?
What are variable report studio?
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 are query items?
what is the use of layout calculation?
What are various types of gateways in cognos?
Explain informatica architecture?
what is stitch query?
What is difference between page break and section report? What is main advantage datawarehousing over oracle?
faq's on cognos
what is field set? what is the query calculation and layout calculation?
Explain what is the difference between microstrategy and cognos reporting tool?
Teradata 
