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
- 6182 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 in detail about type 3?
Can we configure two instances of CMS pointing to two different CMS system databases?
Its regarding Javascript coding for customization in BI4 reports. We need to have all the options disabled in the report except the option to Export(save the report in computer in Excel/pdf formats). I am able to hide TopBar,TabBar,Left Navigation etc but I need "Export" option to be displayed to the users in Read mode. Can this selective "hiding" be achieved?
how to create metric universe ?
Explain difference between zabo and webi?
Explain the difference between union and group?
What is the difference between business requirement document and use case document.
What is the difference between user and versatile user?
What is the functional & architectural differences between business objects and web intelligence reports?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Did you face any problems while creating reports? Name? Solutions?
What is the difference between datawarehousing and businessintelligence?
Is there any other repository domains rather than universe, security, document?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
