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 what are the steps to be taken to schedule the report?
What task is 98% of the required work of a business analyst?
What is difference between custom hierarchy and report based hierarchy?
Explain when to use local filter and when to use global filter?
What is top business?
U r project in which stage in implementation?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
how to create reports on screech?
what is xcelsius architecture?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
What is Indexing? how did u implement indexing?
Can anybody tell me what are the tuning problems?