Modifying ETL process type and actions

The ETL Wizard enables you to select specific warehouse objects to process and modify loading options. These options include:

  • Process type (Full Load/Incremental Load)

  • Behavior of the jobs when dimension processes fail

You can change these options by checking the Select Warehouse Objects to Process on the ETL Job Wizard.

Modify Action on Failure

You can set up each dimension job to continue upon failure of a specific job within the thread. By changing the action on failure, you can define which dimensions should complete successfully before proceeding with fact processing.

Modify Process Type

During ETL job creation, you can modify the process type of each warehouse object. You can compile the stored procedure of warehouse objects with an optional parameter to pass a full or incremental value.

Use these steps to modify the action on failure and the process type.

  1. In the DWD Designer, click the Data Warehouse tab.
  2. Right-click the data mart/model group/model and select Create ETL job.
  3. On the ETL Job Wizard, check:

    • Select Warehouse Objects to Process

    Click Next.

  4. Select the warehouse objects for the ETL job. Click Next.
  5. Verify the loading options of dimension tables, as required, and click Next.
    Process Type

    For process type, select:

    • Full Load: This option uses the full refresh branch in loading the warehouse.

    • Incremental Load: This option uses the checksum logic in loading the warehouse.

    Action on Failure

    For action on failure, select:

    • Continue Fact Loading: This option continues the fact execution when an error is encountered in dimension processing.

    • Discontinue Fact Loading: This option stops the fact execution when an error is encountered in dimension processing.

  6. Verify the loading options of fact tables, as required, and click Next.
    Process Type

    Select one of these:

    • Full Load: This option uses the full refresh branch in loading the warehouse.

    • Incremental Load: This option uses the checksum logic in loading the warehouse.

  7. Confirm the suggested jobs. Click Finish to create the jobs. DWD then creates the requested jobs.
  8. Click OK.