Diff b/w surrogate Key and Primary Key?

Question Posted / arkchowdary

2 Answers
8650 Views
Cap Gemini, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diff b/w surrogate Key and Primary Key?..

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

Diff b/w surrogate Key and Primary Key?..

Answer / krishna

surragate key is a system generated primary key.

Is This Answer Correct ?

4 Yes

1 No

Post New Answer

More Cognos Interview Questions

7. What is performance tuning?

0 Answers

What r the names of the reports that you prepared?

0 Answers

Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!

5 Answers DELL,

can any one say the which is the best performance in framework manager

1 Answers

-----------Diff b/w OLAP and RDBMS?

0 Answers Bank Of America,

i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??

1 Answers TCS,

what are ERP systems?

1 Answers

What are slice and dice?

0 Answers

4. How many dimensions did you use in your reports?