what use of surgate key in project
- 3 Answers
- 6642 Views
- HCL, TCS, I also Faced
- E-Mail Answers
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 |
Explain the different types of views used in cognos.
what are burst options you have?
What is minimum version of internet explorer to run the Cognos report.
what is log in cognos?
What's the differance between each studio in cognos 8?
What is cognos powerhouse?
Hi all, IF any one has Cognos Dump Questions please send it to my mail ID : jaya.purna@gmail.com Cheers Jaya
----------------What is meant by DSS?
What do you understand by the term ‘frame manager' in cognos and write all the layers of the framework manager model?
Any Cognos planning Queries Rise
What is Dynamic Grouping? what is diff between grouping n levelspan?
What are the other methods working as deployment functionality?
Teradata 
