IN2BI, Microsoft Business Intelligence
data, stories & insights
rss | email | twitter

DWH Deck 2.0: Step 2 Add Jobs by selecting source objects and applying a template

The DWH Deck is a simple tool that allows you to build and maintain your data warehouse better and faster.

In a previous blog post we created the solution database and added connections which we’ll use as source or target connection in this post.
In this post we will create jobs that will describe a source to target mapping.

Add the first job with the DWH Deck

  • Click Job in the menu bar
  • Select Northwind in the Source connection listbox
  • Select [dbo].[Categories] in the Source table listbox
  • Select 1 Staging in in the Template listbox
  • Select DW1 in the Target connection listbox
  • Click Save in the menu bar

image

Repeat above steps for the following tables:

  • Customers
  • Employees
  • OrderDetails
  • Orders
  • Products

image

In this step we created the jobs that describe the source to target mapping.
After we have created these jobs we can publish them.
This will be the subject of my next blog post.

Overview of the DWH Deck 2.0

» Similar Posts

  1. DWH Deck 2.0: Step 1 Create solution database and other connections
  2. DWH Deck 2.0: Step 3 Publish the jobs to create the SQL Statements and BIML Files
  3. DWH Deck 2.0: Step 4 Create SSIS packages from the created BIML Files

» Trackbacks & Pingbacks

    No trackbacks yet.

» Comments

    There are no comments.

Comments are closed