what is the use of surrogate key in businessobjects
Answer Posted / prodyot sarkar
surrogate key is a substitution for the natural primary key.
It is just a unique identifier or number for each row that can be used for the primary key to the table. The only requirement for a surrogate primary key is that it is unique for each row in the table.
Data warehouses typically use a surrogate (also known as artificial or identity key) key for the dimension tables primary keys. They can use Infa sequence generator or Oracle sequence or SQL Server Identity values for the surrogate key.
It is useful because the natural primary key (i.e. Customer Number in Customer table) can change and this makes updates more difficult.
Some tables have columns such as AIRPORT_NAME or CITY_NAME which are stated as the primary keys (according to the business users) but not only can these change indexing on a numerical value is probably better and you could consider creating a surrogate key called say AIRPORT_ID. This would be internal to the system and as far as the client is concerned you may display only the AIRPORT_NAME.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the advantages of query studio compared to report studio?
Explain what are components of report studio?
What is index awareness in universe?
What is metadata in context of a datawarehouse?
What is meant by metadata in context of a data warehouse and how it is important?
What is static and local variable?
Explain what is real time data-warehousing?
What is the use of tabular model, tabular sql, tabular reference in real time application?
Where do we use semi and non additive facts?
Explain what are the different types of data warehousing?
Explain the process of extracting data from source systems,storing in ods and how data modeling is done?
What needs to be done while starting the database?
What is latest version of power center / power mart?
What are vaious etl tools in the market?
What needs to be done when the database is shutdown?