what is the use of surrogate key in businessobjects

Answer Posted / samir kumar sahoo

A Surrogate key is a system generated key which is assigned
to be a primary key in the system(table).When data coming
from multiple data sources then there will be a possibility
of duplications and at that situation the system uses the
surrogate key in order to mantain data consistency.

Is This Answer Correct ?    3 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the definition of normalized and denormalized view and what are the differences between them?

520


What is data mart in data warehouse?

533


What is difference macros and prompts?

1715


In microstrategy, how can we direct the sql generated to use a specifc table?

528


Can we have multiple application.cfm file in an application?

482






What are the different types of data warehouses?

569


What are fundamental stages of data warehousing?

535


What are diagrams?

617


Explain how to generate iqd file from framework manager?

509


What a static and local variable?

588


What is the main difference between inmon and kimball philosophies of data warehousing?

652


Explain what is the extension of file to save template?

509


What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?

529


How to create prompts in report net?

555


How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?

547