WebSphere Commerce Analyzer source and staging tables
During replication and extract, transform, and load processes, WebSphere Commerce Analyzer copies information from source database tables and extracts it to staging tables.
Source and staging tables
- All WebSphere Commerce Analyzer staging tables are replicated in condensed mode.
- Source tables have a one to one relationship with the staging tables. That is, for each source table replicated there is one WebSphere Commerce Analyzer staging table and for each WebSphere Commerce Analyzer staging table there is on source table.
- For any given source table, every row is moved into the corresponding WebSphere Commerce Analyzer staging table.
- In some cases, only some columns in a source table are moved into a corresponding WebSphere Commerce Analyzer staging table.
Columns in the staging tables
- Each WebSphere Commerce Analyzer staging table contains a column named LOAD_STATUS, which indicates the current extraction count in which that row was processed. A value of -1 indicates that the row was not yet processed. EXTRACTION_COUNT is a WebSphere Commerce Analyzer parameter. The default value for all new rows is -1.
- Each WebSphere Commerce Analyzer Staging Table contains a column named IBMSNAP_LOGMARKER. This column indicates the time stamp in which the row was altered based on the time on the server. This is true except during the first time a source table is replicated. In this case, the time stamp indicates the time in which the row was replicated. This column is often compared with the WebSphere Commerce Analyzer TIME_CUT_OFF, TIME_CUT_OFF_PREV, WSA_TIME_CUT_OFF parameters, and WSA_TIME_CUT_OFF_PREV, depending on the source server.
- Each WebSphere Commerce Analyzer staging table contains a column named IBMSNAP_OPERATION. The valid values for this are:
- I
- Indicates an insert operation.
- U
- Indicates an update operation.
- D
- Indicates a delete operation.
- Each WebSphere Commerce Analyzer staging table contains a column named IBMSNAP_COMMITSEQ. This column is necessary for replication processing, and not usually used by WebSphere Commerce Analyzer.
- Each WebSphere Commerce Analyzer staging table contains a column named IBMSNAP_INTENTSEQ. This column is necessary for replication processing, and not usually used by WebSphere Commerce Analyzer.
Source server
- The schema name for the WebSphere Commerce Analyzer staging tables is IWH.
- The WebSphere Commerce Analyzer staging table name has the same name as the source server's table name and has the prefix _R. In a few cases, the tablename does not match due to historical reasons (for example, the source table name has changed between releases).
(C) Copyright IBM Corporation 1996, 2006. All Rights Reserved.