ODI SNP & Temporary Tables list ?

ODI SNP & Temporary Tables. 

1)     RKM will store the metadata into below following tables.

1.     Cleans up the SNP_REV_xx tables from previous executions using the OdiReverseResetTable tool.

2.     Retrieves sub models, datastores, attributes, unique keys, foreign keys, conditions from the metadata provider to SNP_REV_SUB_MODEL, SNP_REV_TABLE, SNP_REV_COL, SNP_REV_KEY, SNP_REV_KEY_COL, SNP_REV_JOIN, SNP_REV_JOIN_COL, SNP_REV_COND tables.

2)     LKM Temporary Tables.

a.     C$ table will be created by LKM for load the data from Source table to C$ staging table.

3)     CKM Temporary Tables.

a.     E$ Table for store error records while checking the Dataquality at Mapping level

b.    SNP_CHECK_TAB is a common error table to maintain the high level error details like. Schema name, table name, Error , Error type.

4)     IKM Temporary Tables.

a.     I$ table using for to load the data for integration before going to target table

5)     JKM Temporary Tables.

a.     J$ table for CDC concept to store the PK value into J$ table

b.    T$ Trigger for CDC concept is enabled at source table for DML trigger

c.     V$ View  will display the data for both Source and J$ table join query

d.    V$ DView will be joined both Source and J$table for filter condition with subscriber