Modifying an ETL Load Plan (ODI Only)

You may also want to modify an existing ETL to meet your reporting requirements.

See Also:

• Oracle ® Fusion Middleware Developer's Guide for Oracle Data Integrator 11g/12c

To modify an ETL Load Plan without any changes to the associated tables or columns, perform the following tasks:

1. Identify the Load Plan that needs to be modified in the repository.
2. Identify the Interface/Mapping or Package in the Load Plan that you intend to modify.
3. Open and modify the ETLs (Interface/Mapping/Procedure) in ODI Studio under the Project ArgusAnalytics111.
4. Test and save the changes in ODI Studio.
5. Verify that the changes made have been applied successfully.
6. Regenerate the associated scenario with the Interface/Mapping/Procedure.

To modify one or more tables or columns without any changes to the associated ETL programs (typically to widen a column):

1. Change the table/view properties, as required.
2. Save the Interface/Mapping and regenerate the associated scenario in ODI Studio.