Interested to Buy Any Domain ? << Click Here >> for more details...
HI, can anybody explain me how performence will decrease if
we create objects using derived tables ?
- 2 Answers
- 5166 Views
- I also Faced
- E-Mail Answers
Answer Posted / ashok
by using derived table we can improve the query performance
because that is not created in database it can be designed
at universe designer only.
| Is This Answer Correct ? | 2 Yes | 2 No |
Post New Answer View All Answers
What is package in BO
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain what are the measure objects?
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
What is aggregate table and aggregate fact table ... Any examples of both?
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?
Explain the difference between union and group?
In banking domain how many Fact tables,Dimension table are present?
Explain what would you consider as your biggest achievement and why?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is the difference b/w the refresh and buffered data?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
U r project in which stage in implementation?
BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...
What is the difference between slice and dice and cross tab report?
