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.
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
How to do it…
To create a project object in Data Services, follow these steps:
- Open the Local Object Library window and choose the ...