Interested to Buy Any Domain ? << Click Here >> for more details...
what use of surgate key in project
- 3 Answers
- 7677 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 |
Can we create reports using OLTP database?How?
What is Lookup ,bridgeing tables where they will use in the Dataware house
how to create measures and dimensions?
What snowflake and Starschema?
how you migrate reports to cognos 8 from previous versions?
what is the security module used in cognos?
How to change Boolean variable Yes As "TRUE" and No as "FALSE" in Cognos reporting studio?
what is model and how to create model and how to test model?
How many reports did you create in your project?
hi, i am Having 2 Reports one list report,one crosstab report if i put 2 querys for 2 reports which query will execute first?if i put same query for both 2 which report i will Get?pls pls pls Explain me...
what is loop in frameworkmanager ?
Explain what is the difference between native sql and cognos sql?
Teradata 
