Answer Posted / siddhardha

if Dimension table size(no of rows)exceeds more than 20% of fact table,then the dimension should be flagged as Line Item Dimension. This means that dimension table.Instead,the SID table characteristic takes the role of the dimension table.

What is the use of infocube in the bw system?

892

---

What is compression in the data warehouse?

991

---

Explain customization?

933

---

What are the objects that support documentation?

1942

---

What all data sources you have used to acquire data in sap bw system?

973

---

When we use condition the totals do not match why?

1968

---

What are the advantages of BW 3.x web server (WAS)?

2041

---

What are the different type of infoset joins?

931

---

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

917

---

If you are asked to change the way tables are displayed in web reporting how would you do this?

1791

---

How to fetch the data from sap-r/3, sap-bw/bi to informatica system? what is step by step procedure? at what senario you retrieve the data from sap system to informatica or say dwh system? --

4922

---

What are the advantages of new LO extraction?

2242

---

Define the Lis data flow?

1851

---

What is partitioning and what are the benefits of partitioning in an infocube?

1022

---

List the steps to do the converting from lis to lo extraction.

859

---