OWB Paris : What happened to “Generate intermediate results”???

Prior to OWB Paris, you could easily trap the SQL code that was being generated by OWB in a mapping : you simply had to rightclick on an outgoing group and select “Generate Intermediate Result”.

At first sight, this option disappeared in OWB 10G release 2, but this is not the case… Now, how can you get an intermediate result in OWB Paris? It’s simple … If you know it.

1. Select Generate from the top bar.

2. The Generation Results window will appear.

3. From the dropdown list, select “Intermediate” instead of “Full”.

4. Finally, select the outgoing group of which you want to see the intermediate result.

Like I said : simple, if you know it … ;o)