Interested to Buy Any Domain ? << Click Here >> for more details...
Explain about Short cut join?
- 2 Answers
- 6031 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
hi,
to detect joins automatically go to insert-joins-detect joins..
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain what are the steps to be taken to schedule the report?
what is the source for metrics?
how do we apply sql query on selected variables?
What is pragma?
can anybody tell me about issues faced while creating reports
How to Shedule the reports in Xi R2
How to check for a particular value from one column with the list of values present in another column in Webi reports?
Can anybody tell me the difference b/w canned and adhoc reporting?.
Explain what are the steps to do to use alerts in bo?
What is aggregate table and aggregate fact table ... Any examples of both?
What is Cartesian product?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
Teradata 
