You have now added a new dimension called Component_LabEx_Dim. Next, you will specify where to retrieve the data for the dimension. To do so, you will use a template and specify the columns that you want to load as part of the dimension.
SELECT "REQUEST_ID", {$ETL_DATEID} AS DATE_ID, COMPONENT_ID FROM "RIODS"."REQUEST" WHERE "REQUEST_CLASS_ID"=1
You have now created a new build named F_DEFECT_METRICS, and added the SQL code to specify which records to fetch from the data source.
You have now created a data stream for each element of the data source. You have mapped the DATE_ID element as an attribute, and the TOTAL_DEFECTS element as a measure to contain the count of the attribute element. Next, you will define a fact delivery to specify the location in the data warehouse where this information will be inserted.