XKM: Extract Knowledge Modules

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:

cap

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s