Explain about derived tables?

Answer Posted / vinay

derived tables are logical tables in the universe. to
reduce the query complexity and better query performance or
complex querys we write in derived tables. derived tables
are nothing but sql queries. thease tables can be used in
prompts...

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to open a universe with out using the Designer ??

6624


Explain and tell me about a situation where your analysis of a problem was deemed to be incorrect? What would you have done differently?

820


How to schedule the report in b.o?

566


Can we Save (save as) WEBI Doc as DESKI?

7081


Give some information on report bursting?

573






What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?

1560


Explain about a time when you discovered a more efficient way to do a work task?

644


In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha

1832


What is Indexing? how did u implement indexing?

1820


Explain when to use local filter and when to use global filter?

612


How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?

698


Can we configure two instances of CMS pointing to two different CMS system databases?

1498


What is the difference between absolute and relative div positioning?

588


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

1435


what is document design in boxi,have u participate in that

1663