Diff b/w surrogate Key and Primary Key?

Question Posted / arkchowdary

2 Answers
8755 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

What is difference between page break and section report?

0 Answers

----------------What is Surrogate Key?

1 Answers Cap Gemini,

Can you define a query subject?

0 Answers

How can we Maintain the Cube Security by Category level and Dimension level ?

0 Answers

what are slowly changing dimensions? Why we are used scd?

0 Answers IBM,

What is the difference between macro & Parameter

1 Answers IBM,

What is the usage propertys in Framework Manager?n Ie we set EMP ID as a Fact and what will happen?Actullay EMPID is a Identifier....

4 Answers

How to pass parameter value into html design page?

1 Answers

-------------How to do Bursting a Report?

1 Answers Cap Gemini,

can any body explain clearly how to explain any (sales) project in interview.actually feom where report developer work starts?pls reply as soon as possible.

8 Answers Mind Tree,

how to create relationship between emp and salgrade tables in frameworkmanager?

1 Answers TCS,

How many fact tables and dimension tables in your project?

3 Answers IBM,

For more Cognos Interview Questions Click Here