Monday, 9 March 2015

What are the different temporary tables created in ODI ?

Oracle Data Integrator will create temporary tables during the data transformation and loading/integration.
Let us study about these temp tables.

  1. E$ table: This is generated by Check Control Knowledge Module (CKM) if flow control is enabled.
  2. I$ table: Created by Integration Knowledge Module (IKM). After LKM loads the data into C$ table, the IKM will load these into I$ table.
  3. J$ table: Created during the implementation of Change Data Capture (CDC). This is created by Journalizing Knowledge module (JKM)
  4. 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