Answer / kirankumar

fetching the size of a data from database,how much data fetch one time that is called array fetch size

Answer / vamc

Enter the size of the bind array that
Connection Server uses before sending to
the repository. The bind array is the area in
memory that Connection Server stores a
batch of data to be loaded (sent to the
repository). When the bind array fills, it is
transmitted to the database. Generally, the
larger the bind array, the more rows (n) can
be loaded in one operation, and the better
your performance.

normally we get many contexts when resolving loops or traps,how do u take them to reports.

2 Answers   Wipro,

---

Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?

0 Answers  

---

If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?

0 Answers  

---

how do you give security to universe ?

2 Answers   InfoStep, Tech Mahindra,

---

difference between xir2 and 6.5 version

4 Answers  

---

---

How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?

0 Answers  

---

what is slice & dice?

3 Answers   Cognizant, Saama Tech, TCS,

---

How to get two dimension objects in a same block which are comming from two different contexts ?

1 Answers  

---

Explain the difference between union and group?

0 Answers  

---

HI, can anybody explain me how performence will decrease if we create objects using derived tables ?

2 Answers  

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

4.what is aggregate awareness ? how do we use ? where do we use ?

2 Answers   Accenture, Aegis,

---