What is the use of Surrogate key in BO?

Answer Posted / handy

Surrogate Key is a primary key in datawarehousing, the only
difference between surrogate key and primary key is that
surrogate key allows duplicate values but not primary key.

Is This Answer Correct ?    2 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

U r project in which stage in implementation?

1925


Explain what is aggregate table and aggregate fact table ... Any examples of both?

589


Explain what is the difference between slice and dice and cross tab report?

582


Differences between business objects and web intelligence reports?

629


Explain is there any other repository domains rather than universe, security, document?

560






What task is 98% of the required work of a business analyst?

555


what are the day to day activities of BO administrator ?

1942


How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

546


What is difference between custom hierarchy and report based hierarchy?

530


If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?

524


Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

644


I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!

1729


Can more than 1 metric be applied on an analytic in business objects?

1632


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

569


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

551