System schema changes in this fixpack
The event pattern ETL process provided by this fixpack creates a number of tables in the Interact ETL target database, which is the repository for the results of the event pattern ETL processing to make that data available for reporting.
When you install the Event Pattern ETL process that is provided as part of this Interact fix pack, a set of SQL scripts were also installed in the following location:
<Interact_home>\PatternStateETL\ddl
When you run one of the scripts provided (aci_evpattab_db2.sql, aci_evpattab_ora.sql, aci_evpattab_sqlsvr.sql) against the target data source for the ETL process , you create four tables into which the output from the stand-alone event pattern ETL process is stored. Each of these tables and their schemas are described here.
System schema reference