326 Siebel 7.8 with IBM DB2 UDB V8.2 Handbook
During ETL, the preconfigured Informatica workflows/mappings, identified as the
SDE (Source Dependent Extract) mappings, extract data from source OLTP
database tables by querying views created by DAC with names starting with V_*
and load the data into staging tables on the SRMW database. The view definition
will change depending on whether the ETL run is a full load or incremental load
run. In case of a full load, it would be a “SELECT * FROM <base table>”. While in
the case of an incremental load, the view definition joins the base table with the I
Image tables. This is done to minimize the impact and duration of the ETL
process on the OLTP database.
DAC drops and creates these views during each ...