Use case example – populating dimension tables
In this recipe, we will build the ETL job to populate two dimension tables in the
DimSalesTerritory, with the data from the operational database
For this recipe, you will have to create new job. Also, create two new schemas in the
Transform. To do this, open the SQL Server Management Studio, expand Databases | STAGE | Security | Schemas, right-click on the Schemas folder, and choose the New Schema… option from the context menu. Specify your administrator user account as a schema owner.
How to do it…
- In the first step, we will create extraction processes using these steps:
- Open the job context and ...