When using BI Connector's Microsoft Fabric or ADF pipeline templates to move data from Oracle Fusion to the desired Data Platform, companies prefer capturing the schema changes for certain base tables in rare cases when a newly added column is required for the business or when an existing column is removed or modified.
This article covers the two simple steps to capture the schema changes.
Step1: Drop the particular base table (for which you want to capture the schema change) in your Data Warehouse
Step2: In the Lookup Table referenced by the pipeline, set the LAST_RUN_DATE column across the particular base table's record as NULL
In the next pipeline run, the base table, along with its schema changes will be fully loaded on to your Data platform. In the subsequent pipeline runs, based on your setting for the base table on the Lookup Table, it will be fully or incrementally loaded.