Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surrogate key in businessobjects
- 3 Answers
- 9571 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
Explain what is the difference between view filter and report filter?
What are data modeling and data mining? Where it will be used?
For faster process, what we will do with the universe?
Explain multivalued dependency?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Explain difference between view and materialized view?
What is data analysis?
Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to s.rajanikanth1980@gmail.com Thnx Vani
What are the types of partitioning?
What is a view as it relates to system modeling?
What is the difference between metadata and data dictionary?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain how are the dimension tables designed?
Which component has onread method and what it is used for?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
