what use of surgate key in project
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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
What are the different types of reports present in cognos?
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....
What is meant by grouped star schema
what is the diffence between render variable & style variable with egs? Plz reply ASAP
What is Tool Tip? and how to create in report studio?
What are the services provided in cognos 8?
How do we create row level security in cognos8?
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?
What you mean by drill across?