How can we improve performance?
- 2 Answers
- 6484 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tilak
1)usinf aggregated tables
2)using shortcut joins
3)removing unwanted classes and objects
4)removing unwanted joins
5)lov should be based on smaller look up tables
| Is This Answer Correct ? | 5 Yes | 2 No |
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
which is the best way to resolve loop context r alias why?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
how can we retrieve particular number of rows from data ware house?for EX: my report want to displayed with 10 records in a report??how
what is a filter?
Can we configure two instances of CMS pointing to two different CMS system databases?
Hi friends, How many types of dimentions are they ?What are they? Thanks in advance
What is detailed Object
Can we use two different sources in webirich client to create A report ? Like universe and excel etc...
Explain about alerts in bos, under what situation we need to use alerts?
How to get red line in the graph at some point (value)? Example : In graph at 200000 value
in a database date formate is in dd/mm/yy. In my report I want when I prompt the date coloumn it should be displayed in (yyyy/mmm/dd)format. how could I do this plse send me as soon as possible.
Teradata 
