Interested to Buy Any Domain ? << Click Here >> for more details...
why we are using derived tables ?how it will help?
- 2 Answers
- 6100 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 |
main purpose of aggregate awareness(not include make possible of use of aggregate tables)
What is global filters and local filters
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
How to open a universe with out using the Designer ??
how to prepare the documentation in business objects and where to get the requirement?
What is the difference b/w the simple Universe and Complex Universe?
what is traffic lighting in business objects?
What are the general issues in migration process?
1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?
Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Suppose i have the sinario like this column1: e1,e2,e3,e4 : column2: 1,0,1,0 : column3: M,F,M,F : in this i want to disply 1 is male and 0 is female which is added to the another column like column 4 what is the process?
Teradata 
