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

I want to do on drill calculation? Actually My report is like Continent Amount(Global Currency in dollar) ASIA 200 UK 100 On Drill ASIA Country Amount INDIA 5712(120*47.6) SINGAPORE 128(80 * 1.6) On Drill INDIA State Amount DELHI 3712 CHENNAI 2000

2 Answers  

Explain what are the steps to do to use alerts in bo?

0 Answers  

Hi any done business objects certification.i am expecting some help from them.

6 Answers  

what is the difference b/w the refresh and buffered data?

0 Answers  

what is aggregate navigation?

3 Answers   Countrywide, CTS, HCL,

What are the security level used in BO?

6 Answers   Oracle,

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?

2 Answers   TCS,

I have a report with some hyperlinks,any issue will i get when i migrate this report?

1 Answers   Zensar,

6.what is conformed dimension? R u used?

8 Answers   TCS,

HOW TO PUBLISH A REPORT IN BO?

1 Answers   Polaris,