Use case example – populating dimension tables

In this recipe, we will build the ETL job to populate two dimension tables in the AdventureWorks_DWH database, DimGeography and DimSalesTerritory, with the data from the operational database AdventureWorks_OLTP.

Getting ready

For this recipe, you will have to create new job. Also, create two new schemas in the STAGE database: Extract and 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…

  1. In the first step, we will create extraction processes using these steps:
    1. Open the job context and ...

Get SAP Data Services 4.x Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial