Interested to Buy Any Domain ? << Click Here >> for more details...
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
Can we create universe with no cache??
What is the difference between datawarehousing and businessintelligence?
Explain what sort of existing documents should business analysts refer to when starting on a new project?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
When to use local filter and when to use global filter?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What three things do you consider to be the most important factors for a manager?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
What is package in BO
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.
In banking domain how many Fact tables,Dimension table are present?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
When we use aggregate awareness function in designer?
