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

what is the difference between java script and html in cognos?

1 Answers   IBM,

If you need latest cognos certification dumps to get certified in first attempt with 100% score, please e-mail to getmecert@yahoo.com

4 Answers  

What is Outerjoin?

2 Answers  

What is Index?

2 Answers  

can you apply grouping on crosstab?

1 Answers   CTS,




WHAT ARE THE TYPES OF LIST REPORTS?

4 Answers   Patni,

How to create a cube in Transformer? What is the process? Please mention process thank u

0 Answers   Genpact,

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

6 Answers   CTS,

my cient has reports in java and the dw mart is there already, whether you will suggest for Cognos reports ?

1 Answers   IBM,

im having null data in one of the cell in my report i have to display as "no data" when u run the report how can i achive this problem?

6 Answers   IBM,

If you got any problems while developing the reports, then what will you do? How will you debug the problems? This question isasking in many interviews,,,, pls help me,,,

0 Answers  

what are versions of cognos from starting release to latest in the market?

4 Answers   IBM,

For more Cognos Interview Questions Click Here
Categories