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

any difficulitis have you phase while creating bo reports and how did u solve it

0 Answers  

---

What is meant by ZABO and FC(full-client)?

2 Answers  

---

Suppose we had a scenerio like in an universe there are nearly 250 objects but only 50 objects data is updated frequently so is there any way to overcome it.(Birla Soft,)

3 Answers   BirlaSoft, TCS,

---

Which one will be more preferable creating Derived table or Views on universe level.and Explain why also ?

1 Answers  

---

What is the difference between Sychronisatio and join?

2 Answers   Mind Tree,

---

what is difference between WEBi Report and Crystal Report?

3 Answers   Cognos, Nucleus Software, Red Cross,

---

Explain when to use local filter and when to use global filter?

0 Answers  

---

what are they different types of report in BO?

6 Answers  

---

What is drill across ? can anybody explain me in detail?

1 Answers  

---

How would you format some text using css to be verdana and bold?

0 Answers  

---

why you create universe and creating reports based on that? why dont we go for crystel reports and generate reports directly?tell me the advantages?please answer to this question.

7 Answers   Satyam,

---

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

1 Answers   Zensar,

---