what use of surgate key in project
- 3 Answers
- 6370 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 |
what is #prompt and #promptmany, runningtotal in report studio
It is possible to select more query items in value prompt? i.e when i use drag down i want to display these items like customerid in customer query subject, employeeid in employee query subject and orderid in order query subject..?becoz i want u display when i select a value(ex:customerid)in value prompt ,i need to display another report for all details customer.So, i need how to link for that process...? pls tel me any one knows ,i want to create that report..? thanks , basha
Looking for IBM COGNOS Certification C1000-065 , C2020-605 , C2090-621 , C2090-623 Dumps?
how to explain health care project and which reports we can create in health care doain?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
can anybody tell me when do use 'running total'...give an example for the usage of running total
If you have a report with list and cross tab in the same page. How do you restrict one user can see only the list and the other user can see both.
Can you define materialized view?
1. Differences between Merge and Union In Cognos?
Explain how data modeling is useful to cognos in daily life?
Can you define a datastore in cognos?
What are all types of Batches?
Teradata 
