O'Reilly logo

SAP Data Services 4.x Cookbook by Ivan Shomnikov

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required