|
Answer» Knowledge Modules form the basis of ‘plug-ins’ that allow ODI to generate the relevant execution code , across technologies , to perform tasks in one of six areas, the six types of knowledge module CONSIST of:
- Reverse-engineering knowledge modules are used for READING the table and other object metadata from source databases
- Journalizing knowledge modules record the new and changed data within either a single table or view or a consistent set of tables or VIEWS
- Loading knowledge modules are used for efficient extraction of data from source databases for loading into a staging area (database-specific bulk unload utilities can be used where available)
- Check knowledge modules are used for detecting errors in source data
- Integration knowledge modules are used for efficiently transforming data from staging area to the target tables, generating the optimized native SQL for the given database
- Service knowledge modules provide the ability to expose data as Web services
- ODI ships with many knowledge modules out of the box, these are also extendable, they can MODIFIED within the ODI Designer module.
Knowledge Modules form the basis of ‘plug-ins’ that allow ODI to generate the relevant execution code , across technologies , to perform tasks in one of six areas, the six types of knowledge module consist of:
|