I haven’t managed to find any information around XKMs apart of a basic description from Oracle and I have decided to share what I have found so far.
They are part of the new Component-style Knowledge Modules and therefore they are neither editable nor visible from ODI.
- XKM Oracle Extract.
This knowledge module is used on most of the scenarios (source is a normal table).
CUSTOM_TEMPLATE: Use this option to customise the SQL statement generated on source.
For more information on this topic, please refer to: http://dwteam.in/query-as-source-in-12c/
- XKM Oracle External Table.
This knowledge module is used when the source table is an external table. These are the extract options that can be setup: