what use of surgate key in project

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

pls help me out to find a projects for attending cognos interviews pls anybody send me projects with detail description to explain at the interview time pls send me real time project anybody pls mail me at kittuchoudary2007@gmail.com

1 Answers  


What are the different types of reports present in cognos?

0 Answers  


Hi all, I have a list report with Country, City & Revenue. In the run time i want to hide the particular column. I have tried using Java script but i didn't get any out comes. Please any one share steps for me....

2 Answers  


What is meant by grouped star schema

0 Answers   IBM,


what is the diffence between render variable & style variable with egs? Plz reply ASAP

4 Answers   TCS,






What is Tool Tip? and how to create in report studio?

1 Answers   Wipro,


What are the services provided in cognos 8?

0 Answers  


How do we create row level security in cognos8?

3 Answers  


what are the joins present in reportnet?which is most widely used?

4 Answers   Covansys, IBM, Satyam,


How can you improve performance in report studio level? What is the difference between Cognos sql and Native sql? How can you create cubes in framework manager?

7 Answers   Genpact, iFlex, TCS,


Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  


What you mean by drill across?

0 Answers  


Categories