BI Apps / Oracle Analytics Cloud (OAC) - Change Capture

Change Capture

·        During a full load, Oracle Bl Applications extracts:

— All records from tables that are sources for dimension tables

— Records that were created after an "Initial Extract Date" from

tables that are sources for fact tables

·        During an incremental load, Oracle Bl Applications
extracts:

— Records that have changed or were created after a "Last
Extract Date." This is done by comparing the Last Extract
Date value to a "Last Updated Date" (or LUD) type column in
the source table. If the source table does not have such a
column, Oracle Bl Applications extracts all records from that
table.