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.

how to create dashboard reports

4 Answers   TCS,

---

Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?

7 Answers   Accenture, Wipro,

---

WHAT ALL DIFFERENT OPTIONS PRESENT IN WEBI?

1 Answers   Wipro,

---

explain in detail about type 3?

0 Answers  

---

how we send repotrts/documents to end user

2 Answers   HP,

---

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

0 Answers   Banking, Genpact, TCS,

---

Can any body tell me,What is the universe testing ? What is the report testing Explain?

2 Answers  

---

What Is The Difference Between Oltp And Olap?

0 Answers   Informatica,

---

What is user docs and how to use this option in bo?

1 Answers   Bank of Baroda,

---

What is meant by data federator and what is the use of it?

2 Answers   TCS,

---

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

2 Answers   Infosys,

---

How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

0 Answers  

---