Interested to Buy Any Domain ? << Click Here >> for more details...
HI, Can any body explain me ? If we careate objects using
derived tables it will decreasess the performence? If we
are not creating the objects using the derived tables then
what is the use of having the derived tables?
- 3 Answers
- 4897 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
we can create objects using derived tables
if derived tables increses then only performance decreses
but if we include one object form this table the entire query from this table is executed.we can see this in query panel
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / gowthami
In some scenario’s we cannot meet the requirement. In that case using derived table we can create own query with needed objects and can write the formula to achieve the requirement which cannot be done in general.
If there is no other way to achieve the requirement only the derived table can do. We can go for derived table. But it will decrease the performance of universe (more no of derived tables)
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / raj
Use only when you need complex joins and calculations between tables in the BO universe then go with Derived table.To Update / Change the derived table structure in the universe is very easy
| Is This Answer Correct ? | 0 Yes | 0 No |
How will solve a loop caused by lookup table without using alias?
I need to develop cross tab in format: Values D E F A 1 3 4 B 2 5 8 C 9 8 10 My problem is values in header I am able to do same in WEBI how to manipulate same in deski? Plz Help
Explain what sort of existing documents should business analysts refer to when starting on a new project?
IN BO I HAVE DATASOURCE HAVING THE DATA LIKE "abc" and after creating the Report that is unmathed data like "DEF".what will you do ?
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
why we use aggregation in lower level
Can we start CMS server from CMC? Is yes can anyone tell me how plz Thanks in advance?
what r the main topics to prepare for the crystal reports? could any on help me? i want to preparing for the interviews? and also send any pdf file?
please anyone explain me the derived table with the problem tables.
what are the day to day activities of BO administrator ?
Can some one say abt "ALL" in prompt .. How to get the word "ALL" in the prompt along with the list of values? Plz give me the steps?
What is the difference between business requirement document and use case document.
Teradata 
