Answer / shiva shankar sheela

Prakash, its good you raisd it, but what ever we do in the
BO it needs to connect to Oracle with the help of queries.
As my experience says, its some times necessary to have the
derived tables to be created which needs SQL knowledge, to
do data validation we need SQL queries.

Answer / saichand

Actuaaly for any BO Developer optimum level of SQL knoledge
is necessary.Because In BO we are moslty using oracle is as
database.so what ever you are selecting in the query panel
it is fired on the database in the form of query.All of us
know it is done by designer automatically.But in some
scenarios we have to iplement freehand SQL quries,derived
tables to get our target results and some times we have to
validate the background SQL generated by BO to undrestand
how results are coming in.And in creation of formulas and
variables we need SQL knowledge.
(to_char,to_date,trim,decode,sign,union,union all....)
so SQL is must.Coming to the PL/SQL in some situations when
the data is in huge amounts,normal sql not meet the
required performance.So we have to use PL/SQL.So it is
required in rare cases where you are uplaoding the data in
tthe report automatically by running the Uniox batch or
gatting the hhuge amont of data in to the reports.
As per my knowledge in real time it is better to know abot
the writing the procedures,creating the views are more
enough.
i think cursors,triggers etc.. are used depend upon data
needs.

how to prepare the documentation in business objects and where to get the requirement?

0 Answers   IBM, TCS,

---

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

0 Answers  

---

what is crystal reports?how to migrate them?

2 Answers   IBM,

---

Explain about derived tables?

2 Answers   Cap Gemini,

---

Tell me about a complicated object you have created?

1 Answers  

---

---

I have the one Universe. I take the data from the Excel Sheet. Now i want to get the reports from the two.What is the process

2 Answers   Wipro,

---

How to Avoid the overlaping the blocks in WEBI.

3 Answers  

---

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

---

Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?

0 Answers  

---

What type of schemas did you use in your project?Andwhy did you use that schema

1 Answers   IBM,

---

how to solve the incompatible objects and how they are formed actually.

2 Answers   CTC,

---

HI, Can any body explain me ? If we careate objects using derived tables it will decreasess the performence? If we are not creating the objects using the derived tables then what is the use of having the derived tables?

3 Answers  

---