What is loop in Data warehousing?
Submitted by: AdministratorIn 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.
Submitted by: Administrator
Example: 4 Tables - Customer, Product, Time, Cost forming a close loop. Create alias for the cost to avoid loop.
Submitted by: Administrator
Read Online Data Warehousing Job Interview Questions And Answers
Top Data Warehousing Questions
☺ | What is the difference between aggregate table and materialized view? |
☺ | "A dimension table is wide but the fact table is deep," Explain the statement in your own words. |
☺ | What is the advantages data mining over traditional approaches? |
☺ | What are data validation strategies for data mart validation after loading process? |
☺ | Can you pass sql queries in filter transformation? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |