Interested to Buy Any Domain ? << Click Here >> for more details...
Explain about Short cut join?
- 2 Answers
- 6020 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 |
6.what is conformed dimension? R u used?
how do we schedule reports in WEBI? i want to schedule 3 reports consicutively....how can i achieve this
What is the strategies ? what is the need of the strategies?
What are the differences between webi and deski of XI R2 not the earlier versions
WHAT PROBLEMS ARE NOT KNOWN WHILE PERFORMING INTEGRITY CHECK?
GENARALLY HOW MANY UNIVERSES ARE CREATE FOR EACH PROJECTS?
Explain how to execute the plsql procedure from the report by clicking with mouse?
Explain what would you consider as your biggest achievement and why?
Can we edit BOMain.Key file to connect with other repository with same supervisor user name and password. But Database is different.
Why do we need metrics and sets?
Explain is data mart?
How many universes are required for a single project,and how many reports are required for a single Universe.
Teradata 
