Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

What is the use of Surrogate key in BO?

Answer Posted / mark

A surrogate key from a data warehouse schema is used to join
tables both in general SQL queries against the data
warehouse and for joining tables in the universe schema.

From 6.5.1, it can also be used as part of the keys tab
within object definition to improve query performance in
certain instances.

Given that it has no meaning outside of the data warehouse
technical sphere, it should not be created as an object.

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4714


Explain what is the difference between business requirement document and use case document.

1019


How to open a universe with out using the Designer ??

7601


Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

986


webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??

4406


Explain what are the measure objects?

987


Explain when to use local filter and when to use global filter?

1358


Explain about a tricky situation for which you found a very simple solution?

1007


8. How much supervision have you typically received in your previous job?

2255


Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

1050


If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

1265


can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?

1378


Explain what are the steps to be taken to schedule the report?

1108


In banking domain how many Fact tables,Dimension table are present?

8799


Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?

1949