Answer Posted / sunder

Except:
(
SELECT DEPT.DEPTNO, DEPT.DNAME, DEPT.LOC, EMP.ENAME
FROM DEPT, EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
MINUS
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'JONES')

Both:
(
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ADAMS'
INTERSECT
SELECT DEPT.DEPTNO,DEPT.DNAME,DEPT.LOC,EMP.ENAME
FROM DEPT,EMP
WHERE ( EMP.DEPTNO=DEPT.DEPTNO )
AND EMP.ENAME = 'ALLEN'
)

Match Pattern: LIKE “ABC%”
DFFERENT PATTERN: NOT LIKE “ABC%”

Explain how to schedule the report in b.o?

1051

---

What is the profile and package?

2299

---

What is a bo repository?

1045

---

What is Indexing? how did u implement indexing?

2476

---

Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?

2063

---

What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?

2910

---

Explain 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)?

1064

---

Explain difference between zabo and webi?

1102

---

How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)

4719

---

Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?

1888

---

Explain what is aggregate table and aggregate fact table ... Any examples of both?

1115

---

how to create reports on screech?

2560

---

Difference between zabo and webi?

1110

---

how many reports have u created ? explain a few.

2103

---

Explain what would you consider as your biggest achievement and why?

984

---