You can see the SQL code generated by ODI.
To do this, you have the option to execute a mapping (ODI 12c)/ interface (ODI 11g) in Simulation mode.
Or you can see the code generated in Operator.
But what I really want is generate intermediate sql like OWB.
For example, In a mapping (ODI 12c) I have 2 datastore (A and B), 1 join between A and B, 1 filter post-join and finally 1 datastore C for the integration.
I want te see the where in the join, ignoring filter and datastore C.
1 person found this helpful
ODI will generate the final SQL, as per the steps included in IKM / LKM.