Data Warehousing Community Forum
February 09, 2012, 02:02:24 pm
Home
Help
Search
Login
Register
Data Warehousing Community Forum
>
Reporting Tools
>
Business Objects
>
Short Cut Join
Pages: [
1
]
Go Down
« previous
next »
Print
Author
Topic: Short Cut Join (Read 499 times)
mrinal
DW Fresher
Reputation: +8/-0
Offline
Posts: 23
World is Mine
Short Cut Join
«
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
« previous
next »
Jump to:
Please select a destination:
-----------------------------
General Category
-----------------------------
=> Introductions
=> Anouncements & News
=> Suggestions
=> General Discussion
=> Job Opportunities
-----------------------------
Data Warehousing
-----------------------------
=> Data Warehousing Concepts
=> Data Modeling
-----------------------------
Databases
-----------------------------
=> Oracle
===> PL/SQL
=> Microsoft SQL Server
=> IBM DB2
=> Teradata
-----------------------------
ETL Tools
-----------------------------
=> Informatica
===> Installation & Configuration
=> Data Stage
=> Ab Initio
=> Oracle Warehouse Builder
=> DTS/SSIS
-----------------------------
Reporting Tools
-----------------------------
=> Business Objects
=> Cognos
=> Crystal Reports
=> Hyperion
=> Brio
=> Microstrategy
-----------------------------
Operating Systems
-----------------------------
=> UNIX / Linux
===> Unix Shell Scripting
=> Windows
-----------------------------
Other Technologies & Tools
-----------------------------
=> JAVA