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.

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

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.

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

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.

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.

Answer / chandru

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

Answer / kumaravel.s.t

Surrogate key is the dummy key which is used to allow the
duplicate values

What is meaning of fullpath client in business objects?

1 Answers   Atiric Software,

Tell me about a complicated object you have created?

1 Answers  

5.what is LOV? where it is store?

3 Answers   TCS,

How to execute the plsql procedure from the report by clicking with mouse?

0 Answers  

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

What are the Errors in BO Pls Explain with Examples

2 Answers   iFlex, Tech Mahindra,

where are objects are stored ?

6 Answers   Tech Mahindra,

What are universe parameters?

6 Answers  

what is diff between webi,deski,infoview

2 Answers  

HI i have a table with 4 columns in back end like sales id, sales revenue, order id and order amt. Now i have created 2 prompts at query level 1st on sales id and 2nd on order id. Now if i run the report for 1st prompt it has to display sales id and sales revenue. Then if i run the report for 2nd prompt then it has to overwrite the table with Order ID and order amount. How you will handle this?

1 Answers  

disadvantages of boxi

2 Answers   Accenture,

can BO generate reports with out CUBICAL data to repository?

4 Answers