Interested to Buy Any Domain ? << Click Here >> for more details...
what use of surgate key in project
- 3 Answers
- 7821 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 |
16. How can we create top 10 and bottom 10 records in the same list?
How to hide value prompt box and list when run report?
what is the difference between Cognos EP7 series and Congos8?
What is the use of cognos decision stream?
What are the roles defined by cognos platform?
i wanna some client names and project names in cognos? plz send cognos resumes(3+) exp plz plz plz help me??
Can the expiration parameter of 365 in the cognos 8 configuration how to increase common symmetric key lifetime in days
I have to apply drill through 1,2,7 out of 10 in order method, how can i do?
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
What is zero-foot print?
Can someone tell me whether we can apply filter on list of values in the 'Value Prompt'? e.g. I have a value prompt (named city) and the prompting is holding around 2000 cities but I want to apply filters on cities so users can select only 15 cities out of 2000 and then run the report. Users should be flexible enought to select any 15 cities from the list. Is it possible. Please advice!
Explain the Difference Between Bursting and Scheduling?
Teradata 
