opbang

 Profile Answers by opbang 

• Sep 22nd, 2006

 

In DWH loops may exist between the table. If loops exist, then query generation will take more time, because more than one path is available. It creates ambiguity also. Loops can be avoided by creating aliases of the table or by context.. i.e. defining execution path.

Example : 4 Tables - Customer, Product, Time, Cost forming a close loop. Create aliase for the cost to avaoid loop