Specifying input models from scratch

Specifying input models from scratch means to create an empty input model for the data source, to specify a name for this empty input model, and to select the data source. The data source can be a database connection or a physical data model.

Before you begin

In the Data Project Explorer of the Design Studio, the Data Warehousing project Data Preparation Sample must be available.

Procedure

To create the empty input model Sales_Forecasting from scratch in the Data Preparation Sample project, follow these steps:
  1. In the Data Warehousing project Data Preparation Sample, open the Data Preparation folder, right-click the Input Models subfolder, and select New > Data Preparation Input Model.
  2. On the Project Selection and Input Model Name Specification page of the wizard:
    1. Select the project Data Preparation Sample from the list of Data Warehousing projects.
    2. Type Sales_Forecasting in the Input model name entry field.
    3. From the list of available SQL execution database types, select DB2® UDB and click Next.
  3. On the Model Import and Data Source Type Selection page of the wizard, keep the default selection and click Next.
  4. On the Select Connection page of the wizard, select the database DWESAMP from the list of databases and click Finish. If required, specify your user ID and your password in the popup window.

    The new input model is added to the Input Models subfolder of the Data Preparation folder in the Data Warehousing project Data Preparation Sample.

What to do next

Now you can specify the data to be analyzed for this input model.


Feedback | Information roadmap