2.4.3.1.2.1 Execute Result Area Entities Run Pipeline

The steps to execute the Result Area Entities Run Pipeline are as follows:

Prerequisite:

The SCD pipeline execution should have completed before executing the below steps. For more details, see Slowly Changing Dimensions.

1. Execute the Run Pipeline after data is loaded in the Stage tables and processed.
2. Use the Run Execution Parameter As of Date to execute for each date, to get the data in the result tables. This parameter value is applied as a filter in the source entity on As Of Date Business term.
3. If you execute multiple times within a day, the data is loaded with different Run Execution Skey.
   For example, if the execution is done thrice a day, the data is loaded thrice into the Target table.

   Note:

   You should not re run the already executed pipeline. If you re run, the execution fails due to duplicate Run Execution Skey. You can resume the execution in case of pipeline failures after fixing the errors.
4. If the execution is repeated with the new Run Skey, the entire data available in the Stage table will be loaded to the Target table.