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
What is the difference between datawarehousing and businessintelligence?
How to open a universe with out using the Designer ??
What is the difference between condition & filter?
any difficulitis have you phase while creating bo reports and how did u solve it
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
What is top business?
Explain when we use aggregate awareness function in designer?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Can you please send me the migration related issues .
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
Explain what would you consider as your biggest achievement and why?
Explain the data types present in bo and what happens if we implement view in the designer and report?
Can more than 1 metric be applied on an analytic in business objects?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?
