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 the public object&schema object?

562


Explain in detail about type 2(scd),

587


Explain about a time when you discovered a more efficient way to do a work task?

630


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

7050


Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

1563






What is the dense rank?

665


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

1753


what is document design in boxi,have u participate in that

1655


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

1564


Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?

543


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

574


can anybody tell me about complicated object you have created

2745


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

1962


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

569


What is report template in b.o?

573