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

HOW DO YOU SCHEDULE THE REPORTS?

5 Answers  

---

REGULAR CLASSES for OBIEE Reporting(RPD, Answer, BI Publisher) is Starting From Tuesday, 25th Oct, 7:00 AM IST

1 Answers  

---

What is the difference between condition & filter?

0 Answers  

---

how can u find the granularity in fact table

1 Answers   iGate,

---

What are the different types of connections?Explain?

1 Answers   Wipro,

---

As im new to BO, tel me 1.How to do migration from BO6.5 to BOXIR2? 2.whats the difference b/w BO6.5 to BOXIR2. 3. whats the way both BO 6.5 n BOXIR2 file storge varies.

5 Answers   Cap Gemini,

---

what is mean by lov?

4 Answers  

---

what problems you have faced while creating an universe ? tell me an incident and how you went about solving it? thanks in advance

3 Answers   Patni,

---

can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  

---

solve the following loops? dimension table fact table fact table dimension table link will be there between tables?

4 Answers  

---

What is the difference B/W Variable & Formula? what is ment by incompatable object error in the report level?

3 Answers  

---

1. what is import wizard and its purpose ? 2. what is publishing wizard and its purpose ?

4 Answers   KPIT, TCS,

---