What is loop in Data warehousing?

Showing Answers 1 - 1 of 1 Answers


  • 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

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.


Related Answered Questions


Related Open Questions