Interested to Buy Any Domain ? << Click Here >> for more details...
Diff b/w surrogate Key and Primary Key?
- 2 Answers
- 8777 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 |
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
what type of charts we create mostly in realtime? plz help
what is the different between primarykey and surrogated key.. why we are going for surrogatekey...
What do you mean by Drill down and Drill Up?
how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??
What is the metric store database?
Can you explain new content durability?
What is Cardinality b/w Fact to Fact?
How to select multiple values from type-in prompt?
how can you get the errors in job? when loops are araised we get error?
Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar
what is the generated prompt,how can i use?
Teradata 
