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.

I have Startdate,enddate objects in querypanel and prompt on those objects.how would i get before 2 years data,if i run that query.

1 Answers   Accenture,

---

How will you move reports from Dev to QA in BO

3 Answers   Infosys,

---

explain merge dimensions with real time in DWH?

1 Answers   IBM,

---

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,

---

How we will show the pop message while selecting multiple input values more than 10 in Crystal reports or any other reports?

1 Answers   HCL,

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

---

WHAT IS INPUT CONTROL IN BO?

3 Answers   PWC,

---

WHAT ALL DIFFERENT KIND OF FUNCTIONS AVAILABLE WHILE DESIGNING UNIVERSES?

2 Answers  

---

What is the difference between sub-query & co-related sub query?answer ASAP....... thanks in advance..............Prakash

3 Answers   iFlex, Maintec, TCS,

---

what is stacked chart , Bar chart, Column chart?

1 Answers   Tech Mahindra,

---

what r the types of joins universe supports

3 Answers  

---

How to Implement the the Built-in Strategy Script in BO Designer?

2 Answers   Infosys,

---