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

What is vldb(very large databases)?

542


Whether dimension table can have numeric value?

604


What is the difference between snowflake and star schema?

583


Explain dimension table ?

560


What is the difference between power center and power mart?

553






How to create different types of templates?

516


What is data warehosuing hierarchy?

581


How to import vsam files from source to target. Do we need a special plugin?

509


How to test report in reportnet?

566


What is the metadata extension?

537


Describe a data warehouse.

547


Explain which columns go to the fact table and which columns go the dimension table?

520


What is analytical or analytic mean?

616


What is surrogate key? Where we use it? Explain with examples.

544


What is informatica architecture?

605