Release 0.0.5 of map_reconstruct script

New release of map_reconstruct script now supports new feature of lookup operator in OWB11g R2:
- multiple input and output groups in single lookup operator
- all types for selecting single row ("Multiple Match Rows" section in lookup configuration wizard)

SCD2 lookup currently is not supported

Download from OWBLand Sourceforge project

Corrected bug in last release of map_reconstruct script

There was a bug in last release (0.0.3) of map_reconstruct.tcl script (unwanted backslash in multiline conditions in "if" operators). So download newer release 0.0.4 from OWBLand Sourceforge project (look for file map_reconstruct-0.0.4.tcl).
Release 0.0.3 isСохранить как черновик removed from files repository.

map_reconstruct script update - better support for OWB11g R2

I released new version (0.0.3) of map_reconstruct.tcl script. Now this script supports OWB11g R2 "unified" mapping datatypes. Earlier releases of this script lost detailed info for several datatypes (for example, for NUMERIC datatype precision and scale properties always was zero, or zero value for length property of VARCHAR datatype).
Also I changed processing of JOINER operator - previous releases finished abnormaly in OWB11gR2 on mapping with joiner.
Download new release (0.0.3) of map_reconstruct.tcl script from OWBLand Sourceforge project

Recovering OWB mapping with map_reconstruct.tcl script

There is another case for using MAP_RECOSTRUCT.tcl script (except using for export/import mappings between environments). Sometime dueto OWB bug/OWB repository corruption it is impossible to open map for editing in Design Center (in my practice this happened twice as I remember). The problem usually in single operator or attribute.
In this case we can use MAP_RECOSTRUCT.tcl script for identification problem object in mapping - run this script against such corrupted mappings and script outputs in generated file error message which allow identify problem object. Release 0.0.2 of MAP_RECOSTRUCT.tcl script already contains code which output into target file comments if error raised (and script won't stop!) during extraction properties for attribute - so it is possible to get working copy of corrupted mapping...

MAP_RECONSTRUCT script update

I slightly modified script (and OWB Expert) for generating OMB script for recreating mapping, link for download  script and OWB expert

All modifications are errors correction:
- escaping additional character in expressions and join/filter conditions
- supporting key lookup operator in OWB 11gR2 (in this release OMB returns different from previous releases type name for key lookup)
- added processing of error during extraction attribute properties (in case of error attribute will be created with NUMBER datatype, in generated script inserted comment with description of problem)

For first two identified and corrected bugs thanks to Patrick (unfortunately I don't know him full name)!