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

what is xcelsius architecture?

0 Answers   Zensar,

---

HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?

2 Answers  

---

In a context can i get the data from two different factables by using the single data provider?

2 Answers   IBM,

---

Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?

0 Answers  

---

3.what is alias?

5 Answers   Business Intelligence Analytics, TCS,

---

---

wha is the difference b/w merge dimension and combining two different data providers?

1 Answers  

---

Can any one gve me the complete information abt Certfication of Business Objects ?

2 Answers  

---

WHERE DO YOU USE GLOBAL FILTERS ,EXPLAIN WITH EXAMPLE?

2 Answers   PCS,

---

what is the use of merge option in webi reports? explain with example?

2 Answers   TCS,

---

The business object 6.5 version is possible for created dashboard reports.if possible how is generated universe to dashboard reports

1 Answers  

---

what is crystal reports?how to migrate them?

2 Answers   IBM,

---

Explain what would you consider as your biggest achievement and why?

0 Answers  

---