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 the difference between business requirement document and use case document.

952

---

Explain what are the steps to be taken to schedule the report?

1036

---

Explain in detail about type 2(scd),

1041

---

Explain about a tricky situation for which you found a very simple solution?

934

---

How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.

2385

---

is it possible to export the webi reports to crystal reports?with out using businessview?

2220

---

Explain the data types present in bo and what happens if we implement view in the designer and report?

955

---

Can we Save (save as) WEBI Doc as DESKI?

8025

---

Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye

1820

---

How to open a universe with out using the Designer ??

7444

---

What are the data types present in bo? What happens if we implement view in the designer and report?

968

---

How to do impact analysis for a change in Database field size which is assigned to a Dimension object and used in 10 universes

2364

---

What three things do you consider to be the most important factors for a manager?

1028

---

How many universes can be created in a project?

972

---

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

997

---