Defining a process

Use the Process notebook to create a folder that holds processes you create with the Process Model window. A process is a series of steps, which commonly operates on source data, that changes data from its original form into a form conducive to decision support. A Data Warehouse Center process commonly consists of one or more sources, one or more steps, and one or more targets.

Link to the Moving and Transforming Data task in Related information to learn how to use the Process Model window.

../byb.gifAuthorities and privileges

To create a process:

  1. Open the process notebook.

  2. In the Name field, type the name of the process.

    The name must be unique within the Data Warehouse Center. The name can be up to 80 alphanumeric characters and is case sensitive. You cannot use & as the first character in English.

  3. In the Administrator field, type the name of the person who is responsible for the process definition, for example, your database administrator.

  4.  Optional: In the Description field, type a description of the process.

    You can view or search for text that you enter in this field. If you publish metadata for the process, users can view it in the information catalog. Your description can be up to 255 characters in length.

    The description is also displayed in the Description column in the pane on the right side of the window when the Process folder is clicked.

  5.  Optional: In the Notes field, type any additional information about the process that might be helpful to users who access the process. For example, you can use this field to maintain a list of changes to the process definition.

    The notes can be a maximum of 32,000 characters in length.

  6. Click the Security Groups tab.

  7. From the Available warehouse groups, select the warehouse groups you want to grant access to the process and click >. The groups you select are moved to the Selected warehouse groups list.

    If you want to include all the groups in the Available warehouse groups list, click >>.

  8. Click OK.

    Your new process is displayed when you expand the Processes folder.

Related information:

Moving and transforming data

Changing the properties of a process

Data Warehouse Center security

Glossary of terms