Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using derived tables ?how it will help?
- 2 Answers
- 6140 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mayur
hi,
see i would like to answer it through on example:
consider the case where u retrive the data from the table xyz
by writing the "SELECT STATEMENT" & get the output ( say 5 rows) now their is the condition ....where u need this output(5 rows) for report/query..etc..
now, in such condition you can create an object of the above statement i.e "Select Statement" and store it in Derived table
& hence next time u will not require to write sql again...
& even a complex sql is effectively implemented...
finally this will enhance ur performance & a effective development logics ....
| Is This Answer Correct ? | 0 Yes | 4 No |
Instead of Aggregated table we use the Derived table.
Aggregated table will be created by ETL people, for
summarized columns we use Aggregated table.
| Is This Answer Correct ? | 0 Yes | 9 No |
What is a join? Explain different types of joins?
Explain the difference between detect alias and detect context?
Explain what are the measure objects?
Can we link the oracle and excel universess?
My data source is Excel sheet. How to write the SQL Statement for Excel file in data provider? Is is possible?
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
What is a universe?
Explain what is the difference between slice and dice and cross tab report?
What is the need of live office connector
HOW DO YOU RESOLVE MULTIVALUE AND COMPUTATIONERROS?
Hi, In BO at universe designer i had four tables which has many to many relationships between the tables. How to fetch the correct results in the report?
What is Indexing? how did u implement indexing?
Teradata 
