Answer / 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 v1,v2 and v3 updates?

3 Answers   Cap Gemini,

---

What is percentage share?

2 Answers  

---

What is Cell Definition ?

1 Answers   Satyam,

---

Define a data source?

3 Answers  

---

best institute in ameerpet for SAP bi/bw

4 Answers  

---

what is meant by flat aggregate?explain in detail

1 Answers   Rockwell, TCS,

---

What is the ODS object settings?

2 Answers  

---

Can you make multi providers and master data as data marts?

1 Answers  

---

We have standard info cubes given in sap why you created zinfo cubes can u tell me the business scenario

0 Answers   Rockwell, TCS,

---

Where do you find which table is currently being populated (BIW1 or BIW2)?

0 Answers  

---

What is hierarchy?

2 Answers  

---

How many types of infocubes are there?

3 Answers  

---