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

Explain what are the measure objects?

933


Did you face any problems while creating reports? Name? Solutions?

3640


what is xcelsius architecture?

4521


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

958


can anybody tell me about complicated object you have created

3172


Explain is there any default username & pwd for bo designer & supervisor?

946


Explain how many universes can be created in a project?

1008


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

1164


How to sort the dynamic objects alphabetically on the Universe based on and SQL Server

2228


any difficulitis have you phase while creating bo reports and how did u solve it

3387


What is package in BO

3147


What three things do you consider to be the most important factors for a manager?

1029


What is the difference between business requirement document and use case document.

957


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

922


Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2363