Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Surrogate key in BO?
- 8 Answers
- 17992 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 |
if we run a report it is taking so much time to display the report,what to do to increase th performance of the report
can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?
How to create predefined filters in B.O.
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.
How to change the order of prompts in universe?
Can anybody tell me the difference b/w canned and adhoc reporting?.
Difference between drill by and drill across with example?
Ranking feature was not available in WEBI 6.5 version,So how can we get ranking in WEBI 6.5 version?
what is prompt? Cascading prompt? Syntax
How to create Generic TIME CLASS, which includes Objects Year,Month and Qtr?
Explain what is the difference between slice and dice and cross tab report?
Teradata 
