Projects and jobs – organizing ETL
Projects are a simple and great mechanism to group your ETL jobs together. They are also mandatory components of ETL code organization for various Data Services features, such as Auto Documentation and batch job configuration available in the Data Services Management Console.
Getting ready
There are no preparation steps. You have everything you need in your local repository that has already been created. In this recipe, we will use Job_DWH_DimGeography
developed in Chapter 5, Workflow – Controlling Execution Order, to populate the DWH dimension tables DimSalesTerritory
and DimGeography
.
How to do it…
To create a project object in Data Services, follow these steps:
- Open the Local Object Library window and choose the Projects tab.
- Right-click in the empty space of the Projects tab and select New from the context menu. The Project – New window appears on the screen.
- Input the project name as
DWH_Dimensions
in the Project Name field. - Open...