Interested to Buy Any Domain ? << Click Here >> for more details...
When we are going for Shortcut join and why.
- 1 Answers
- 5749 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / pvraobo@gmail.com
Shortcut join is a join that provides an alternative path between two tables.shortcut join improve the performance of a query by not taking into account intermediate tables.
Note:This is only used per improving the report performance.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
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 is the difference between slice and dice and cross tab report?
Explain how we drill up week to month?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Explain is there any other repository domains rather than universe, security, document?
Explain how many universes can be created in a project?
Differences between business objects and web intelligence reports?
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?
Explain about a time when you discovered a more efficient way to do a work task?
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 how to execute the plsql procedure from the report by clicking with mouse?
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain the difference between union and group?
How were the reports scheduled and how to resolve unexecuted documents?
