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

What is the difference between absolute and relative div positioning?

586


What is difference between webi and infoview?

617


What are the steps to be taken to schedule the report?

558


What is the difference between datawarehousing and businessintelligence?

622


What is top business?

569






what is the difference b/w the refresh and buffered data?

1765


Explain the difference between union and group?

632


What is Indexing? how did u implement indexing?

1820


What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2403


Can anybody tell me what are the tuning problems?

1592


Can we Save (save as) WEBI Doc as DESKI?

7078


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3847


i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?

1614


Which versions are used in the bo dashboard work?

603


Explain which versions are used in the bo dashboard work?

635