Answer / naga bhushanam.banglore

Slowly changing dimensions(SCD) is the type of dimensions
which changes with respect to time or peeriod.

Fo s ex: there is an table which has objects like
Country City Employeeid ddress .

Here for example the say the employee of employee id say
e23321 is presently in Hyderabad after a month he is re-
located in Banglore than we can say the address dimension
is SCD w.r.t. time

We have 3 types of SCDs:
SCD-1
SCD-2
SCD-3
SCD-1:where no historical data is not maintained only
present data is maintained
SCD-2:Where complete historic + presentl data is maintained
SCD-3:Where one time historic(say previous) data+ current
data is maintained

Answer / mrs.narmatha

Slowly changing dimension applies to some cases where
attribute for a record varies over time.

For example a person called narmatha lived in one place
(india). So the original entry in the customer lookup table
like : customer id :100 name: narmatha country:India

At a later the person moved to UK

How should XYZ Inc. now modify its customer table to
reflect this change? This is the "Slowly Changing
Dimension" problem.

Can Bo generates the reports from cubical data ? Explain?

2 Answers   IBM,

---

HI ALL, CAN ANY PLEASE TELL ME HOW TO CREATE HYPERLINKS IN WEBI.THANKS IN ADVANCE

2 Answers  

---

What is meant by Adhoc reports?Can any body will explain with examples...Thanks in Advance .........prakash

7 Answers   TCS,

---

How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?

1 Answers  

---

what is the different between link and join ?

2 Answers  

---

What is a join? Explain different types of joins?

5 Answers  

---

what is the necessity of oracle for business objects,why the interview panel is concentrating on oracle very much? Just we need the commands using select,joins? why they r asking about cursors,triggers etc..can any body answer me ..........Thanks in advance prakash

2 Answers  

---

What is top business?

0 Answers  

---

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

---

What are the Users and User groups?

2 Answers   Wipro,

---

How we can add a comment in universe...?

1 Answers  

---

What is the sheduling the report? What is the need of sheduling the report?

1 Answers   Wipro,

---