4.6.2 Executing the Data Slicing Function

You can execute this procedure from the Batch processing screen (Common Object Maintenance and select Operations).

1. A seeded batch INFODOMNAME_DATA_SLICE_POPULATE is provided with the Task component of TRANSFORM DATA. The following are parameters for the task:
   Datastore Type: Select appropriate datastore from list
   Datastore Name: Select appropriate name from the list
   IP address: Select the IP address from the list
   Rule Name: Upd_DataSlice_Dim_Code
   Parameter List: Number Of Processes, List of Table names, Column Name.
   The last two parameter values must be enclosed in single quote
   Example: 8, 'FSI_D_MORTGAGES, FSI_D_ BORROWINGS', 'DATA_SLICE_ID'
2. If you want to execute this procedure directly from the database, for example using SQL Developer or a similar tool, the function fn_POPULATE_DATA_SLICE_CODE can be used. This function requires five parameters: BATCH_RUN_ID, AS_OF_DATE, IN_NPROC, IN_SOURCETABLELIST, IN_COLUMN.
   The syntax for calling the procedure is:
   function fn_POPULATE_DATA_SLICE_CODE(BATCH_RUN_ID varchar2 ,AS_ OF_DATE IN Varchar2,IN_NPROC IN Number, IN_SOURCETABLELIST INVarchar2, IN_COLUMN IN Varchar2)
   Where,
   BATCH_RUN_ID is any string to identify the executed batch. When executed from Batch this parameter is automatically generated. When it is executed directly in database then an appropriate value must be passed.
   Example:
   'OFSALMINFO_DATA_SLICE_1' AS_OF_DATE in YYYYMMDD format enclosed in single quote.
   Example:
   ‘20190101’IN_NPROC this numeric value is used to identify the number of processes and will be same as number of members created for Data Slicing dimension.
   Example:
   8IN_SOURCETABLELIST List of the tables with comma separated source values.
   Here, table name should be in single quote. If more than one table names are given then single quote should be at the beginning of list and another at the end of the list, for example : 'FSI_D_MORTGAGES, FSI_D_ BORROWINGS'. IN_COLUMN is the name of the column where Data Slide Id gets updated. DATA_SLICE_ID is the seeded column. You can choose another column if applicable as long as it is present in the instrument tables.
3. Example:
4. Navigate to Common Object Maintenance and select Operations, and then select Batch Maintenance window.
5. Search for the data slicing batch (INFODOMNAME_DATA_SLICE_POPULATE) as displayed:
6. Edit the corresponding task as displayed.Example of Parameter List: 8, 'FSI_D_MORTGAGES, FSI_D_ BORROWINGS', 'DATA_SLICE_ID'
7. Navigate to Batch Execution.
8. Search for the batch as mentioned following and execute it using Batch Execution.

   Note:

   When you are executing the batch, the batch execution date should be the same as the As of Date when the processes are getting executed.

   • All the messages (including warning and error) are logged in the FSI_MESSAGE_LOG table.
   • It is a mandatory step to execute the above procedure with relevant parameters prior to executing ALM, BSP or FTP processes if you want to make use of this feature.
   • This feature is only relevant when multi-processing is enabled and will not result in any performance improvement when number of processes = 1.
   • All parameters are mandatory in expected order and format.