When updating metadata calculations, the ETL process validates at Step 21. This validation takes the ETL_Calculations values, ensures the set calculation will execute successfully, and that the ETL process will not fail. If for some reason the new calculation causes a failure, all metadata calculations will revert to the default calculations and the ETL process will continue. The log will report any failure of the calculation and give a warning that the calculations will be reverted. You will have an opportunity to correct and rerun the ETL process. Errors will only be reported in the log. Once the calculations are successful, you can continue the ETL process as normal, with a normal StarETL run.
To validate the calculations:
In Linux, run staretl.sh -from 18 -to 21.
In Windows, run staretl.bat 18 21.
In Linux, run staretl.sh.
In Windows, run staretl.bat.
The calculations for each table and column are stored in the ETL_CALCULATIONS table. To change a calculation of one of these fields, you must run an update statement in the Star schema.
For example, you could run the following statement:
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:
/
Tips
Related Topics |
Legal Notices
Copyright © 1999, 2014,
Oracle and/or its affiliates. All rights reserved.
Last Published Friday, January 31, 2014