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 difference between custom hierarchy and report based hierarchy?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is top business?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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 would you consider as your biggest achievement and why?
What is the difference between business requirement document and use case document.
Explain what is the difference between business requirement document and use case document.
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
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
Differences between business objects and web intelligence reports?
Can anybody tell me what are the tuning problems?
what will be the contents for a functional requirements specifications
