Interested to Buy Any Domain ? << Click Here >> for more details...
what is the use of surrogate key in businessobjects
- 3 Answers
- 9262 Views
- EDS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / 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 |
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
Explain the data types present in bo n wht happens if we implement view in the designer n report?
Can a dimension table contain numeric values?
What is difference between query studio and report studio?
Why we use repository connectivity?
How to provide security in frame work manager for a query subject?
What should I have in mind when building olap solution from scratch?
What is the difference between dependent data warehouse and independent data warehouse?
why oracle is the best database for data warehousing?
What is difference between Mapplet and reusable transformation?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
How to create prompts in report net?
Teradata 
