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
Explain the definition of normalized and denormalized view and what are the differences between them?
What is data mart in data warehouse?
What is difference macros and prompts?
In microstrategy, how can we direct the sql generated to use a specifc table?
Can we have multiple application.cfm file in an application?
What are the different types of data warehouses?
What are fundamental stages of data warehousing?
What are diagrams?
Explain how to generate iqd file from framework manager?
What a static and local variable?
What is the main difference between inmon and kimball philosophies of data warehousing?
Explain what is the extension of file to save template?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
How to create prompts in report net?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?