1. User Guide
  2. Utilities
  3. Data Slicing
  4. Process flow

4.6.1 Process flow

To utilize this functionality the following steps must be performed before executing an ALM, BSP or FTP process with multi-processing enabled:

  • Create members for the Data slicing dimension through the dimension management screen (Dimension Management -> Members). Members should be numeric values like 1, 2, 3, and so on. It is advised that the maximum number of members be limited to the number of processors (CPU’s) available on the Application Server for executing ALM, BSP and FTP processes in the environment.
  • Execute the database procedure ‘Upd_DataSlice_Dim_Code’ (via a seeded Batch DATA_SLICE_POPULATE: This procedure updates the Data Slice Id column in every instrument table with the values defined in step 1. Instrument records are equally distributed among all members. For more information, refer to Executing the Data Slicing Function section.

    Note:

    Numeric values are assigned individually within each instrument table. For example, if you have 4000 records in table 1 and 4000 in table 2 and 4 unique data slice values, each table will get updated with 1 through 4 data slices.
  • Setup multi-processing (Navigate to Common Object Maintenance and select Process Tuning) Select the Data Slice dimension under the Data Slicing Columns section. See the ALM and FTP user guides for more detailed steps.