What is the use of Surrogate key in BO?
- 8 Answers
- 16548 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 short cut join?
What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash
User name and password is saved by Business objects when we create repository. and this username and password is saved in Table obj_m_actor table in repository. The password in incrypted form. It is possible to Dycrypt That Password.
What is the difference between Boxir2 and Boxir3?
Can we link the Universes from two different sourcess?Explain?
bo 6.5 is a 3 tier architecture. Tell me the names of the tiers?
How to create an popup in the WEBI report if the report is showing partial result?
How will solve a loop caused by lookup table without using alias?
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
1.what is input level context and output level context in webI? 2.what is a cascading prompt? Where will you give this and how? 3. What is External Strategy?
Teradata 
