Sign Up Login


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

what use of surgate key in project

Question Posted / pradeep

Answers were Sorted based on User's Feedback



what use of surgate key in project..

Answer / kumar

Hi,

Surrogate are System generated sequential Values.

We use these keys to maintain the Historical data in EDW&
to set up relationship between Dimension Table & Fact Table.
It plays a key role in Maintain Historical data in EDW.

We prefer these Keys Even we have the Primary key Columns
in the Tables, since a customer may purchase several times
in a single day irrespective of time & Bill No. are
different.
In this situation we take these keys that give different
No. for several times Purchase in a single day.

Is This Answer Correct ?    4 Yes 0 No

what use of surgate key in project..

Answer / sindhuchowdary5

Surgate is a system generator sequence,by using this we can
store the historical data tha means it stores the type 2 data,
it acts as primary key in dimension table

Is This Answer Correct ?    1 Yes 1 No

what use of surgate key in project..

Answer / fgdfgd

Surgate is a system generate key , using this key we can maintain historical data in DWH .

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Cognos Interview Questions

I have prompt date prompt (from and to), country and city, how to get data from jan1/2012 to jan31-2012.

2 Answers   IBM,

What is namespace and what it holds?

7 Answers   IBM,

Hi Friends, Just want to know, day to day is increasing or decreasing Cognos Usage in the Market? New Reporting tools to driving Reporting Market Spotfire, Tableau,Qlick View, some other New Tools. Which Reporting tool can generate Lot of Opportinities in the Market? Please Reply to this, My Advanced Thank to you. Thank You Kumar

2 Answers  

---------------What is meant by Scheduling?

2 Answers   IBM,

What is the difference between Standard and Metrics folder?

0 Answers  




Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,

what are the dimensions that you have in your current project?list them?

0 Answers   IBM,

What is the difference between ‘macro’ and ‘prompt?

0 Answers  

Hi Friends,what are The Advantages In Cognos 10 Compared To Cognos 8.4?Enhancements in Cognos 10? Please Ans Me Pls

1 Answers  

what is the main advantage of impromptu over cognos reportnet?

0 Answers  

if report performance is low how can check 3 areas in framework manager?.what are the 3 areas concentrate?

3 Answers   CTS, TCS,

What is power prompts?Can somebody explain me.

2 Answers  

For more Cognos Interview Questions Click Here
Categories