Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6061 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Explain how to schedule the report in b.o?
Explain when we use aggregate awareness function in designer?
Can Bo generates the Report from the cubical data Explain?
Is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
Which versions are used in the bo dashboard work?
Explain in detail about type 1?
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Did you face any problems while creating reports? Name? Solutions?
Give some information on report bursting and how to do it in bca as I have to split the report and send diff reports to diff people?
8. How much supervision have you typically received in your previous job?
Explain about alerts in bos, under what situation we need to use alerts?
webI report not showing Barcode in PDF format, i have used BC39 font,but barcode is shown in HTML but not in PDF, please any solutions??
