Oracle Data Integrator will create temporary tables during the data transformation and loading/integration.
Let us study about these temp tables.
Let us study about these temp tables.
- E$ table: This is generated by Check Control Knowledge Module (CKM) if flow control is enabled.
- I$ table: Created by Integration Knowledge Module (IKM). After LKM loads the data into C$ table, the IKM will load these into I$ table.
- J$ table: Created during the implementation of Change Data Capture (CDC). This is created by Journalizing Knowledge module (JKM)
- C$ table: The LKM creates the "C$" temporary table in the staging area. This table will hold the records loaded from the source server.
No comments:
Post a Comment
Do not spam here