Answer Posted / anu
A shortcut join is a join that provides alternate path
between two tables.Shortcut joins improve the performance
of a query by not taking into account intermediate tables,
and so shortening a normally longer join.
A common use of shortcut joins is to link a shared lookup
table to another table further along a join path. The join
path comprises several different tables in the same
context. In such a case, the shortcut join is only
effective when the value being looked up has been
denormalized to lower levels in a hierarchy of tables, so
the same value exists at all the levels being joined.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain when we use aggregate awareness function in designer?
How would you format some text using css to be verdana and bold?
Is there any other repository domains rather than universe, security, document?
What is Indexing? how did u implement indexing?
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...
What is top business?
WHAT ARE THE META DATA TYPES?WHICH META USING IN BO'S
what are the tables used in health care domain project and columns used in report?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
Which versions are used in the bo dashboard work?
What is the difference between condition & filter?
What is the difference between slice and dice and cross tab report?
Explain as a ba (business analyst) approaching a new piece of work, who would you interview and what questions would you ask?
U r project in which stage in implementation?
Explain when to use local filter and when to use global filter?
