Interested to Buy Any Domain ? << Click Here >> for more details...
What is the use of Surrogate key in BO?
- 8 Answers
- 18562 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 |
Can anybody tell me . Is it required CMS Server for Desktop Intelligence Reports?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
what are the debuggings in the business objects?
Hai, Can anyone tell me 'how to use one dataprovider result as an input to another dataprovider?. In BO6.5 there is an option like "select query result". we can use this option in the filter. but the same thing not available in BO XI webi. if any one face this problem , can you please share with me how to do this? Thanks, Narmatha.
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
Difference between b.o 5.1 and 6.1b?
how to do scheduling in desktop intelligence in BO XI R2
3.what is alias?
5 Answers Business Intelligence Analytics, TCS,
What three things do you consider to be the most important factors for a manager?
how can we build one report from two data bases
I have a situation like one manager can have multiple learners under him. each learner will registered for more than one certifications . their statuses for different courses like completed, inprogress, dropped, no certifications. the question is i have check for each user for statuses if he had some completed certifications i have to get latest completed date and omit all other stauses. if he had no complete staus then i have to get latest inprogress record based on date. like this i have to select only one record for user. but i am getting one row for each status. among all completion status one record, for all inprogress one record, for all dropped status one record. how can i show only one record
how do u resolve contexts ?
Teradata 
