Diff b/w surrogate Key and Primary Key?

Question Posted / arkchowdary

2 Answers
8770 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 Cognos Powerhouse and what is it used for?

2 Answers IBM, M Care,

what is dimention?explain dimentable with example?

3 Answers Syntel,

What are the uses of query explorer? Give example for each use in detail. It is not given clearly in user guide so explain in detail.

1 Answers

. how will we hide the “report title ” in pdf format, but title should be remain unchanged in html format.

3 Answers

What will happen if scheduling a report with a prompt page?

1 Answers Ness Technologies,

Tell me about Dnamic and Static Dashboards?

0 Answers

how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.

0 Answers

What are all the components of Report Studio?

0 Answers

What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?

0 Answers

How to create measures and Demensions?

2 Answers

Can any one tell me cognos training class in chennai? thanks in advance...

5 Answers

what is an outer join? difference between left outer join right outer join with an example?

1 Answers HCL,

For more Cognos Interview Questions Click Here