Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between derived table and views?
which one gives better performance?
- 2 Answers
- 24933 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / pradeep mishra
Always View is better than Derived Tabels because it
fetches the Data Directly through the Database So as per
the Performance related it's too good.
But,When we want to use @Function (@variable,@prompt) in
your Query that time it's only possible in Derived
Table,not in the VIEWS.
| Is This Answer Correct ? | 21 Yes | 0 No |
Post New Answer View All Answers
Can more than 1 metric be applied on an analytic in business objects?
What is aggregate table and aggregate fact table ... Any examples of both?
How we drill up week to month?
When we use aggregate awareness function in designer?
Hi friends,
I am trying to create OLAP connection in IDT. I am getting
error "error code:405 METHOD NOT ALLOWED"
I am using "http:
Explain about a tricky situation for which you found a very simple solution?
Explain is there any default username & pwd for bo designer & supervisor?
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
explain in detail about type 3?
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
What are the join problems comes appart from loop,chasm & fan Traps
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
Explain the data types present in bo and what happens if we implement view in the designer and report?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
