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:
- In the Data Warehousing project
Data Preparation Sample, open the Data Preparation folder, right-click
the Input Models subfolder, and select .
- On the Project Selection and Input Model Name Specification
page of the wizard:
- Select the project Data Preparation Sample from the
list of Data Warehousing projects.
- Type Sales_Forecasting in the Input
model name entry field.
- From the list of available SQL execution
database types, select DB2® UDB
and click Next.
- On the Model Import and Data Source Type Selection page
of the wizard, keep the default selection and click Next.
- 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.