- 17.9K All Categories
- 3.4K Industry Applications
- 3.3K Intelligent Advisor
- 66 Insurance
- 536.8K On-Premises Infrastructure
- 138.4K Analytics Software
- 38.6K Application Development Software
- 5.9K Cloud Platform
- 109.5K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
Import / create Integration knowledge modules
I am new to ODI and was going to catch some exceptions such as making sure what is passed is a number instead of varchar, or validate the length then record these exceptions into a different table.
Came to tutorials and notes that it seems like I should be using Check Knowledge Module which seems to be linked with Integration Knowledge Module being used while mapping. From what I read this will catch exceptions and put them inside an E$_table, so I want to try it out.
I was using VM ODI downloaded from https://www.oracle.com/middleware/technologies/data-integrator/odi-demo-downloads.html
It includes an append Integration Knowledge module, then I started using the big data lite VM from https://www.oracle.com/database/technologies/bigdatalite-v411.html which is more updated version of ODI and the Oracle Database too.
But in the big data lite ODI, I do not see the append option in Integration Knowledge module, I wonder if there's a way I can either export from the previous VM then import into the new VM. I was checking googling but most of them were talking about exporting / importing environment, repositories and so on.
Can someone shade me some light on how to progress?
Thanks in advance for any suggestions and advices.
P.S. If I am actually on the wrong road of wanting to catch exceptions to another table such as if `TO_NUMBER(value)` gives an exception error or if even possible `LENGTH(value) != 5` something like these. Please let me know and if can lead me to where I can find tutorials with images, I really appreciate the help.
Thanks a lot