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
What is vldb(very large databases)?
Whether dimension table can have numeric value?
What is the difference between snowflake and star schema?
Explain dimension table ?
What is the difference between power center and power mart?
How to create different types of templates?
What is data warehosuing hierarchy?
How to import vsam files from source to target. Do we need a special plugin?
How to test report in reportnet?
What is the metadata extension?
Describe a data warehouse.
Explain which columns go to the fact table and which columns go the dimension table?
What is analytical or analytic mean?
What is surrogate key? Where we use it? Explain with examples.
What is informatica architecture?