Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


What is the use of Surrogate key in BO?

Answers were Sorted based on User's Feedback



What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

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

What is the use of Surrogate key in BO?..

Answer / chandru

Surrogate key is unique key which is used in type 2
dimension.

Is This Answer Correct ?    2 Yes 4 No

What is the use of Surrogate key in BO?..

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

Post New Answer



More Business Objects Interview Questions

What is the Drill filter and it's usage?

2 Answers  


what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,


What is the functional & architectural differences between business objects and web intelligence reports?

0 Answers  


Can anybody tell me what are the tuning problems?

0 Answers  


what are cascading prompts explain with steps

4 Answers  






2.What is loop? How resolve the loop?explain it?

11 Answers   TCS, UHG,


What is the BO project Architecture? Explain in detail? Thanks in advance for ur answers?

2 Answers   Patni,


How to take backup of CMS database and Auditing database, please suggest me with a best possible ways.?

1 Answers  


Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

0 Answers  


When upgrading from 3.1 to 4.0. Which services need to run ONLY? Do ALL services need to be running?

2 Answers   TCS,


Explain is there any default username & pwd for bo designer & supervisor?

0 Answers  


Hi All, If anyone of you had very Latest & Authentic BUSINESS OBJECTS - XI Certification Dumps for the below Codes, can you please forward it to me, its really very urgent to me SABE 201, SABE 301, SABE 401, SABE 501V3.0 Thanks Mohan

3 Answers  






Categories