Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


Explain about derived tables?

Answers were Sorted based on User's Feedback



Explain about derived tables?..

Answer / 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

Explain about derived tables?..

Answer / srini

Some times the main query needs a driving query in FROM
clause, which is not possible to build. So we use derived
tables to fix this.
Example:
SELECT
----
FROM
TABLE1,
( SELECT
---
FROM
TABLE2
)DERIVED_TABLE
WHERE
TABLE1.COLUMN = DERIVED_TABLE.COLUMN;

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Business Objects Interview Questions

How can you check the universe?

3 Answers  


Approximatly how many enduser can use the each bo project?

4 Answers   HCL,


in BO module, you forgot all password even all user in business object, designer, supervisor, gen.supervisor everythicg, how to you recover your datas?

1 Answers   iFlex,


How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?

2 Answers  


What is the short cut join?

2 Answers   Wipro,


can anybody explain me in detail about software development life cycle of business objects in detail?

1 Answers  


how to add duplicte rows to the existing report in webi ?

1 Answers   HCL,


What is security level in BO ?

3 Answers   Accenture,


how did u give developed universe to ur client?

1 Answers  


how u link universes of same functional domain ?

2 Answers   Business Intelligence Analytics, IBM,


I am working on Business Objects-reporting side. Database is Teradata. I have two questions here: 1. We will be working only on Infoview on QA environment. Do I need to add ODBC entries for the QA database server on my machine to be able to create/refresh Infoview reports? I will not be using Desk_I or Web_I rich client. 2. Once reports are developed,Admin team would migrate the reports to Production and make these available to business users. The reports are Refresh on Open. Would the business users need to have the ODBC entries of Production database server in their machines to be able to refresh these reports?

2 Answers  


Explain about alerts in bos, under what situation we need to use alerts?

0 Answers  


Categories