Data Warehousing Community Forum
February 09, 2012, 02:02:24 pm

Pages: [1]   Go Down
  Print  
Author Topic: Short Cut Join  (Read 499 times)
mrinal
DW Fresher
*

Reputation: +8/-0
Offline Offline

Posts: 23


World is Mine


View Profile
« on: January 05, 2009, 03:03:42 pm »

Short Cut Joins are used to improve the query performance at universe level.
Suppose if we have 4 tables A,B,C and D

A--->B---->C---->D and  there is a chance to link A--->D  but we should not link (causes loop) and we need data from the tables A and D then it will get the data in the path A--->B---->C---->D , it consumes lot of time and resources.

In this case instead of linking A---->D using normal join we should link A and D by using short cut join and this will not create any loop and get the data in the path
 A--->D, it consumes less time and resources.


Someone can put more light on this....
Logged
Pages: [1]   Go Up
  Print  
 
Jump to: