This section provides an example of how to change a STARETL process default calculation. Each row in the ETL_CALCULATIONS table represents a calculation that can be changed. In order to change a calculation, you must be logged on to the Primavera Data Warehouse instance with the schema owner account (for example, STARUSER). Additionally, you must use a database update statement followed by a commit.
The following example shows how to update the default calculation for a row called EMERGENT_WORK:
- Log in to Primavera Data Warehouse (with SQL Plus, SQL Developer, and so on) with the user account for the schema owner (for example, STARUSER).
- Run the following command:
update etl_calculations set calculation = 'CASE WHEN a.actual_start_date >= s.period_start_date and a.actual_start_date <= s.period_end_date THEN 1 ELSE 0 END' where column_name = 'EMERGENT_WORK' and TABLE_NAME='W_ACTIVITY_HISTORY_F'; commit: /