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
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what three things do you consider to be the most important factors for a manager?
What is aggregate table and aggregate fact table ... Any examples of both?
Explain about a tricky situation for which you found a very simple solution?
Can we create universe with no cache??
Difference between zabo and webi?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
What are the data types present in bo? What happens if we implement view in the designer and report?
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 how to schedule the report in b.o?
Explain how we drill up week to month?
What three things do you consider to be the most important factors for a manager?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what are the day to day activities of BO administrator ?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message