In this example, the DimProduct, DimProductSubcategory, and DimProductCategory tables are integrated into one query. This query will include all product rows, only the English language columns, and user-friendly names.
Figure 33: Source Tables for Product Dimension
Many-to-one relationships have been defined in the source database.
- Create three queries for each source table and disable their loads.
- Use query group folders in the Query Editor to isolate these queries.
Figure 34: Staging Queries
- The gray font indicates ...
