Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surrogate key in businessobjects
- 3 Answers
- 9257 Views
- EDS, I also Faced
- E-Mail Answers
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 stages of datawarehousing?
Define Data Warehousing?
Explain what are the tasks that loadmanger process will do?
For faster process, what we will do with the universe?
Explain what is the difference between stop and abort?
What are the various transformation available?
How would you declare an inline css to format the table with a background color of yellow and give the table cell a right margin of 10 pixels?
What are the steps of implementing data warehousing?
What is is a star schema?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain a mapping, session, worklet, workflow, mapplet?
What is batch processing?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Explain the difference between data ware house & data mart?
Explain what is the data type of the surrogate key?
