I migrated a collection of mappings from OWB to ODI 12.2.1. When I run one of the mappings I get an ORA-01722:
invalid number error message. I would like to debug the sql code generated by
the mapping using the ODI debug function. I click Run/Debug/Start debug Session,
accept the defaults on the Debug dialog and click okay. The system displays an error ‘…ensure that there
is one step in the in the session execution.’
I would like to know how to get started on using the debug
tool to debug a mapping. What is the session execution and how do I add steps?