Answer Posted / arun
Surrogate key is a unique identification key, it is like an artificial or alternative key to productionkey, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
what are the tables used in health care domain project and columns used in report?
Give some information on report bursting?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
When we use aggregate awareness function in designer?
Can you please send me the migration related issues .
When to use local filter and when to use global filter?
Explain how to schedule the report in b.o?
What task is 98% of the required work of a business analyst?
What are the steps to do to use alerts in bo?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain how we drill up week to month?
Explain how many universes can be created in a project?
in sap bi we have wad, then why we go for sap bo
Explain how to execute the plsql procedure from the report by clicking with mouse?
what are the day to day activities of BO administrator ?
