Answer Posted / soujanya

Nesting of queries, one within another, is termed as a Sub-
Query.

A sub query is executed once for the parent statement
whereas the correlated sub query is executed once for each
row of the parent query.
Example
Select deptno, ename, sal from emp a
where sal = (select max(sal) from emp
where deptno = a.deptno)
order by deptno

What is aggregate table and aggregate fact table ... Any examples of both?

1000

---

Explain is there any other repository domains rather than universe, security, document?

1002

---

Difference between zabo and webi?

1050

---

In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

2215

---

What Is The Difference Between Oltp And Olap?

1059

---

WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S

2194

---

Migration of Reports from business objects 5.1.5 to samee version in different hardware?

2269

---

What is the profile and package?

2247

---

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

1164

---

Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com

2363

---

What is difference between custom hierarchy and report based hierarchy?

951

---

8. How much supervision have you typically received in your previous job?

2202

---

What is the difference between business requirement document and use case document.

957

---

Explain how to execute the plsql procedure from the report by clicking with mouse?

983

---

What sort of existing documents should business analysts refer to when starting on a new project?

965

---