1. Categories >> Software >> Data Warehouse >> Cognos
  2. Suggest New Category

Diff b/w surrogate Key and Primary Key?

Question Posted / arkchowdary

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

Q1. Why do we use determinant? Please explain with examples? Q2. What is new arrive dimensions? Please explain with examples? Q3. Suppose we have a table which is holding a large number of records. There are 4 columns which are very frequently used in the Cognos reports, so can we create indexing on those 4 columns?

2 Answers   Mphasis,

how can you restrict the number of values available for a prompt? i tried this by using static choices property, but i dint get result... so pls explain in detail steps....

3 Answers  

Which service handles requests for cognos connection,query studio and event studio.

3 Answers   HCL,

difference between stored procedure and function?

4 Answers   Syntel,

Hi,please suggest me how to creat username while creating a report.

1 Answers   IBM,




In an existiing Framework model, how will you add a new column to the existing table?

6 Answers   CTS,

What is Cardinality b/w Fact to Fact?

4 Answers   IBM,

How do you create IQD in FWM? Pls, give the procedure with an example. I told him that we could create using Native SQL method in FWM; it is correct or do you do another method there?

4 Answers  

how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com

0 Answers   NEC,

Where do i get Cognos 10 BI Online Training in Low price for the below tools. Cognos Framework Manager Cognos Report Studio Cognos Query Studio Cognos Analysis Studio Cognos Event Studio Cognos Transformer Cognos TM1 Development

11 Answers  

1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.

0 Answers  

How can we create a dynamic column name in cognos?

0 Answers  

For more Cognos Interview Questions Click Here
Categories