what is the necessity of oracle for business objects,why
the interview panel is concentrating on oracle very much?
Just we need the commands using select,joins? why they r
asking about cursors,triggers etc..can any body answer
me ..........Thanks in advance prakash
- 2 Answers
- 5233 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Explain difference between zabo and webi?
how do u implement dense rank in bo reports?
What is the use of Surrogate Key in BO?
I have a column contains a data like A,A+,A++,B,B++ how u going to sort ther data?
In a context can i get the data from two different factables by using the single data provider?
i am facing date format issue in webi report in BI4.0 environment. i have unx based on Mysql connection. date is coming in 10 digits numeric format like(2345623456). I want to change it in dd.mm.yyyy format. Please suggest
WHAT IS CARDINALITIES OF JOIN?
what are the all possible reasons of getting partial result on a webi report?
1. What is difference SAP BW, SAP BI and SAP BOXI integration? 2. Which is good for carrier wise? 3. Which is latest one (BW/BI/SAP BOXI Integration)?
How many universe dfi you create if you have 2 years of experience in BO
what are the tables used in health care domain project and columns used in report?
Hi frns, In the report level i have dragged objects in the query panel. If i check the sql query it is displaying 2 separate queries. What will be the possibilities for this?
Teradata 
