Hi,
I am trying to understand some of the new features that is added in ODI 12c. Seems like the ODI 12c Developer guide (https://docs.oracle.com/middleware/1212/odi/ODIDG.pdf) did not cover the mentioned topics below. Is there any other documentation available apart from the developer guide that talks about this. Answers for these Questions are much appreciated. Thanks.
1. What XKM does really? All I am aware is that it cannot be edited nor created by User and it can be used to substitute Source SQL,
2. How XKM influences the SQL generation?,
3. How to see the code generated by XKM?,
4. Does Oracle External XKM replace any of the Template KM's or 11g Standard KM's Example. LKM File to Oracle (EXTERNAL TABLE)?
5. Also regarding the new ODI 12c Knowledge Module skeleton (i.e. Mapping Begin, Execution Unit Begin, Execution Unit Main, Execution Unit End, Mapping End, Mapping Cleanup). Is there any specifics to know about this? For Example the tasks defined under Mapping Cleanup will be executed if 'Remove Temporary Objects on Error' Check box is enabled in Mapping. Similarly is there any specific options available for these headings or it is just a coding practice to group related tasks?
Awaiting Answers.