What is the use of Surrogate key in BO?
- 8 Answers
- 16001 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sri
When we transfer the data from the source to the target
tables i.e dimension tables,we will be having one primary
key for the dimension table,but in the scd type 2 will be
having the repetative data i.e history+current data,so we
will be using the surrogate key for the dimension tables for
identifying the
rows uniquely this surrogate is implemented in the ETL
process by using the "Sequence Generator Transformation".
The surrogate key will be act as primary key in
the scd type 2 and primary of dimension table will be the
natural key.
| Is This Answer Correct ? | 11 Yes | 2 No |
Answer / ravinder singh
Surrogate key is contigeous numbers generated by DB in a
table which acts as a primary key since surrogate key has
unique values.
for eg :
101,102,103,104,105............ so onl
| Is This Answer Correct ? | 6 Yes | 1 No |
Answer / bhaskar
When we transfer the data from the source to the target
tables i.e dimension tables,we will be having one primary
key for the dimension table,but in the scd type 2 will be
having the repetative data i.e history+current data,so we
will be using the surrogate key for the dimension tables for
identifying the
rows uniquely this surrogate is implemented in the ETL
process by using the "Sequence Generator Transformation".
The surrogate key will be act as primary key in
the scd type 2 and primary of dimension table will be the
natural key.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / arun
Surrogate key is a unique identification key, it is like an artificial or alternative key to productionkey, bz the production key may be alphanumeric or composite key but the surrogate key is always single numeric key. Assume the production key is an alphanumeric field if you create an index for this fields it will occupy more space, so it is not advisable to join/index, bz generally all the datawarehousing fact table are having historical data. These factable are linked with so many dimension table. if it's a numerical fields the performance is high
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / mark
A surrogate key from a data warehouse schema is used to join
tables both in general SQL queries against the data
warehouse and for joining tables in the universe schema.
From 6.5.1, it can also be used as part of the keys tab
within object definition to improve query performance in
certain instances.
Given that it has no meaning outside of the data warehouse
technical sphere, it should not be created as an object.
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / handy
Surrogate Key is a primary key in datawarehousing, the only
difference between surrogate key and primary key is that
surrogate key allows duplicate values but not primary key.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / chandru
Surrogate key is unique key which is used in type 2
dimension.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / kumaravel.s.t
Surrogate key is the dummy key which is used to allow the
duplicate values
| Is This Answer Correct ? | 4 Yes | 9 No |
what is the difference b/w star and snowflack schema in dataware house?
Migration of Reports from business objects 5.1.5 to samee version in different hardware?
how to create metric universe ?
4.what is repository? types
8. How much supervision have you typically received in your previous job?
What is the difference between Sychronisatio and join?
WHAT IS THE PURPOSE OF TESTING INTEGRITY OF THE UNIVERSE?
What are the general issues in migration process?
How to link one location universe to other location universe
WHAT ARE THE DISADVANTAGES IF WE HAVE MORE FACT TABLES IN UNIVERSE?
can we create aliases for every table beforehand? if yes whar are the disadvantages?
IF VIEW IS FASTER THAN DERIVED TABLE WHY WE ARE USING DERIVED TABLE IN BUSINESS OBJECTS?
Teradata 
