Answer / nareshkumar

Dimensions that change over time are called Slowly Changing
Dimensions. There are three types namely,
1) Overwriting the old values
2) Creating an another additional record
3) Creating new fields

Answer / surya

Master data occur in the OLTP system and that can't change
regularly,When the changes are occured in the OLTP
system,that changes can be handle by the dimension
tables.Such type of dimensions is called Slowly changing
dimensions.

There are three types of dimensions
TYPE1(Maintain only current data)
TYPE2(Maintain complete historic data)
TYPE3(Maintain one historic data)

Answer / mahesh225

The data present in the dimension table changess from time to time.

For example .

Customer is staying in Inda now and he may moves to Us in next year.Similerly from Us to Uk and so on.

So to maintain this kind of dimentional historical information we have SCD type1,Type2 and Type3.

www.futuresoftworld.com

Thanks

define universe parameters?

5 Answers  

---

while migrate bo 5.1 report into boxir2 ,what are the problems faced

2 Answers  

---

i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest

3 Answers  

---

Can we link the Universes from two different sourcess?Explain?

2 Answers   IBM, Oracle,

---

Who launches the supervisor product in Business Objects for first time?

2 Answers  

---

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

1 Answers   IBM,

---

Any one suggest me best SAP Business Objects XI Online Training institute from India

2 Answers   Aetna,

---

WHAT TYPE OF JOINS RETURNS INCORRECT RESULTS?

2 Answers  

---

CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?

7 Answers  

---

1. what is the purpose of creation of universe than other data sources ? 2. which is the best method in performance tuning techniques ?

3 Answers  

---

What Is Snow Flake Schema?

0 Answers   Informatica,

---

When we can use multiple sql statement for each measure? and multiple sql statement for each context?

2 Answers  

---