Posted by: Peter Scott | February 16, 2008

OWB map testing

I am still overseas working on a OWB project for a client. We are now into that final phase of checking everything before we promote the first release to the production system. Each OWB map for the first release is redeployed on the development system and then test data run through the map – we then check that the right number of rows (and content too!) appears at the right target. This is painstaking, but necessary work. Where we have problems we track them down, resolve (redeploy if we need to alter the mapping) and then repeat the test until the problem goes. When we get all of the code in the first release working, we go through the loop again for all of the maps to see the affects of using the SCD2 functionality in the dimension load plug-in (and yes, we have applied that patch to remove the horrendous “compare effective dates as text strings” coding that somehow crept into OWB) We are looking to make sure that execution times don’t go off on the update rather than pure insert operations of the first round of testing

Which brings me to a nice OWB 10.2 feature in trouble-shooting complex maps. The ability to generate code for indivdual mapped object input or output groups; Click on the code generator icon on the map editor and click on a drop down on the code window to change the mode then click on a mapped objects grouping bar. If I loose one or two rows in a mapping (or even all of them) I just cut and paste the generated code into SQLDeveloper and check that each output is doing the right thing

About these ads


  1. Dear Peter,

    Where can I find the patch that you’re talking about?

    We’re hitting major performance issues and I think that this dates comparisons could be on of the causes.

    Thank you for your help.

    Best regards,


  2. I can’t find the patch number for now – I guess that a SR with Oracle should identify the patch required. It needs to go on the OWB development clients as this is where the PL/SQL gets generated

    Sorry I can’t be much more help on this one

  3. Thank you for your answer Peter.

    I’ve already open a SR but no luck… I’m using 11g so I’ll have to wait until the next patch to get this issue solved. Until then we are changing (after each deploy) the code of the package on the database…

  4. Although no help to those on 11g – the OWB patch is now out on Linux and Windows – look for patch 7005587 on metalink

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s



Get every new post delivered to your Inbox.

%d bloggers like this: