Answer Posted / binu v. rajan

in star schema master data tables are inside the cube.

demerit of star schema
limited analysis is possible since only 16 master data
table can be accommodated in a cube.

alpha nummerical values are getting posted in fact table
that may degrade the perfomence.

master data table cant reuse for any other cubes.

in ext. star schema

Surrogat id tables are genearated with the activation of
master data table. based on sids dimention id will genarate
and the dimention id will get posted in fact table.

so charactorstic value will not be there fact table insted
did's and kf will be there.

master data table can be re used since its out side of the
cube.

3224 master data table can be used in fact table through
dimention table.

What is the use of real-time infocube? How do you enter data in real-time infocubes?

977

---

When to virtual providers based on dtp?

1007

---

What are the different categories of infoobjects in bw system?

1065

---

What is a repair request?

1983

---

Give an example of CO-PA fields at the operating concern that are not replicated?

1992

---

How do you transform open hub data?

1360

---

Can any 1 plz tell me How to identify the missing delta's to run the repair full request,and vat are the extractors used in lo cockpit,if i use filter on condition which 1 will execute first?,

2443

---

What are the steps to create classes?

2222

---

I have cube.for cube data coming from 3dso's.in one dso having special chars.in cube you got special char error.how u can resolve this?

1884

---

please tell me the most frequently asked interview questions about sap BW with answers

5027

---

What is an infopackage?

1024

---

What is web template.

1031

---

Explain table partition?

1052

---

What are the conversion routines for units and currencies in the update rule?

1011

---

what do you mean by update routines

1025

---