This view provides a denormalized view relating products to all Retail categories which they belong. For example, if Prod1 ...

This view provides a denormalized view relating products to all Retail categories which they belong. For example, if Prod1 product is assigned to Cat2 category and Cat2 descends from Cat1 category, there will be two records linking Prod1 to both Cat1 and Cat2.