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.

My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?

3 Answers   TCS,

---

can anybody explain me in detail what is the difference between desktop intelligence and web intelligence in detail?

2 Answers  

---

how to link 3 fact tables

1 Answers  

---

Example of how the fantraps and chasm traps works?

1 Answers   IBM,

---

Explain in detail about type 2(scd),

0 Answers  

---

IN WHICH DIFFERENT SCENARIOS WE CAN USE @AA FUNCTION?

1 Answers   Accenture,

---

what is difference between folders and category ?

4 Answers   Tech Mahindra,

---

how can u find the granularity in fact table

1 Answers   iGate,

---

How to sheduling the report ? What is the need of it?

2 Answers   Infotech,

---

1.How is "Query drill" mode different from standard drill mode?. 2.Under what circumstances are you most likely to choose to use "Query drill" mode instead of standard query mode?. 3.How do you implement the type2 slowly changing dimensions in your project?. 4.what is meant by Junk dimension?. 5.what is meant by Drill across?.

2 Answers  

---

What is object stores?

0 Answers  

---

what is local filter

2 Answers   Cap Gemini,

---