Data Warehousing Question:

What is loop in Data warehousing?

Answer:

In DWH loops may exist between the tables. 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.

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

Download Data Warehousing PDF Read All 131 Data Warehousing Questions

Previous Question	Next Question
What is an error log table in Informatica occurs and how to maintain it in mapping?	How many clustered indexes can u create for a table in DWH? In case of truncate and delete command what happens to table, which has unique id.