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
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id 347 what is hybrid slowly changing dimension?
Explain what are components of report studio?
Explain what are conformed dimensions?
What are snapshots? What are materialized views & where do we use them?
What are the stages of datawarehousing?
What is vldb(very large databases)?
What is Active Datawarehousing?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
What is the difference between olap and datawarehosue?
Where the applications and where ware house management system is used?
What are the possible data marts in retail sales?
What is difference between e-r modeling and dimensional modeling?
What is the metadata extension?
What is operational data store (ods)?
What is latest version of power center / power mart?