Answer Posted / pbs
yes.We can't create views in Universe.views are stored as SQL.Derived tables are stored as tables.Exection is faster in case of derived tables as it operates on the new table directly ,but views are SQL and executes and operates on the source table and then fetches te records.Advantage of view is any changes in source table will also get reflected in view,but in derived table it is not possible.
| Is This Answer Correct ? | 0 Yes | 5 No |
Post New Answer View All Answers
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What is report template in b.o?
Explain which versions are used in the bo dashboard work?
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
Explain about a task that really tested your analytical abilities?
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
what is universe null
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??
Explain about a tricky situation for which you found a very simple solution?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what is the difference between business requirement document and use case document.
Explain about alerts in bos, under what situation we need to use alerts?
Explain the difference between detect alias and detect context?
Difference between b.o 5.1 and 6.1b?
Explain is there any default username & pwd for bo designer & supervisor?