Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using derived tables ?how it will help?
- 2 Answers
- 6118 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 |
how many reports have u created ? explain a few.
1 Answers InfoStep, Ness Technologies, TCS,
What is the pragma?
How to execute the plsql procedure from the report by clicking with mouse?
What is the equivalent oracle operators for following BO Operators where we use in prompt: a. Different from pattern b.Match pattern c. Both and d.Except
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
How we drill up week to month?
What are the major problems will occur while migrating to the one version to another version?
How to get two dimension objects in a same block which are comming from two different contexts ?
without creating the business view is there possible to create & generate the Crystal reports?
Report have 10000 records,how to restrict the end user to 1000 Records?
How can I display the query execution time for a particular DP on Web-I report? Or is there any other way to know the 'exact query execution' time at BO end?
What are the Errors in BO Pls Explain with Examples
2 Answers iFlex, Tech Mahindra,
Teradata 
