In the solution I describe in the main article, I used the destination Products_TypeN dimension tables as the bindings tables in the Data Driven Query (DDQ) tasks. Because the dimension tables don't contain bit columns that indicate an attribute...
When a product is deleted from your production system, you don't necessarily want to delete it from your data warehouse; you probably keep historical data that correlates to the discontinued products. In the scenario I discuss in the main article...