Answer Posted / g k ramesh

1.In star schema the central fact table is surrounded by
master data tables(=dimension tables).since master data
lies with in the cube.we can not reuse the master data
information for other cubes.where as in Extended star
schema the central fact table is surrounded by dimension
tabes(!=master data tables).master data tables lies out
side the info cube.so,we can share the master data
information for other cubes.

2.In star schema the fact table holds Alpha-numaric
information.so,it degrades the database performance and
query performance.where as in Extended star schema using
SID tables we can see all the information in the fact table
as numaric.so,it improves the database performance and
query performance.

3.In star schema the fact table is directly connected to
the master data tables and it can be connected to a maximum
of 16 master data tables.so,we can not analyze the data
more then 16 angles.where as in Extended star schema the
fact table is connect to maximum 16 dimension tables and
each dimension table can be connected to a 248 SID
tables.so we can analyze the data in 16*248 angles

How would you do the calling a bw query from an abap program.

927

---

What is data flow in bw/bi?

955

---

which patch u used presently? How can I know which patch that one?

1425

---

what are the drawbacks of cubes?

970

---

What is geographical information in the sap bw?

910

---

Explain multiprovider?

896

---

Tell something you know about the dimension in the warehouse and how it can be optimized?

885

---

What is the data flow from LIS tables to BW?

1975

---

what is direct schedule and what is meta chain

2455

---

Can you add programs in the scheduler?

1017

---

What is SAP exit?

2098

---

What are processing commands?

1931

---

What are the destination target options?

1992

---

describe how you have used excel as a compliment to bex?

913

---

What is the use of real-time infocube?

815

---