Data Management

Developing a Knowledge Module in Oracle Data Integrator

Free registration required

Executive Summary

Knowledge Modules (KMs) in Oracle Data Integrator are components that implement reusable transformation and ELT (extract, load, and transform) strategies across different technologies. One example of this is extracting data through change data capture from Oracle Database 10g and loading the transformed data into a partitioned fact table in Oracle Database 11g, or creating timestamp-based extracts from a Microsoft SQL Server database and loading this data into a Teradata enterprise data warehouse. The power of KMs lies in their reusability and flexibility - for example, one can develop and implement a loading strategy for a fact table and then, with a click of a mouse, apply this loading strategy to all of the fact tables.

  • Format: HTML
  • Size: 0 KB