What is the use of Surrogate key in BO?
- 8 Answers
- 16031 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 |
why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.
wat is report linking in BO..I know that 2 reports can be linked in BO with the help of writing a HTML code .But how. wat s the code.can u give me the example of code taking e fashion as the simple univers data provider.
How toconnect one to one report?
Can We customize the Business Object infoview in BO?
What is the merge dimension?
How would you format some text using css to be verdana and bold?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Without using OBJECTS Can i write AND run a query in webi/desi? HOW?
how to create metric universe ?
Approximatly how many enduser can use the each bo project?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
u drag 2 sources from 2 diff dataproviders,how we take these 2 sources into 1 single report, how we give the link these 2 sources
Teradata 
