Diff b/w surrogate Key and Primary Key?
- 2 Answers
- 7849 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 materialised view? why we use it in data warehousing?
at what level u prepared the reports in cognos???? in dataware housing what is the automation tool u r using???
1 Answers Covansys, IBM, Wipro,
Why cognos scenario is used?
What are the ways to import data into catalog?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
hi, this is harish. i had finsihed cognos course recently.can some one help in the area of project explination, interview questions,real time scenarious....this is my maild id nanagupta907@gmail.com
What is Parametermap?
Sales person are there in one company How to do Bursting on this particular requirement?
What is the function of model design accelerator?
What you mean by drill across and what is the difference between drill through, drill across?
Define dimensions?
What is the advantage of using shortcuts?
Teradata 
