I started development of OMB*Plus program for generating mapping creation script (sometime it is better to use OMB for moving OWB objects to other environment).
Current status - implemented processing for 50% of operators (see table below) and processed a limited list of operator properties (for example not processed EXTRACTION_HINTS, SCHEMA, etc. properties). You can download it from map_reconstruct.tcl.
Implemented operator processing
Implemented operator processing
| Operator type | Planed to implement | Implemented | Processed operator properties |
|---|---|---|---|
| ADVANCED_QUEUE | |||
| AGGREGATOR | x | x | GROUP_BY_CLAUSE, HAVING_CLAUSE |
| ANYDATA_CAST | |||
| CONSTANT | x | x | EXPRESSION |
| CONSTRUCT_OBJECT | |||
| CUBE | ? | ||
| DATA_GENERATOR | |||
| DEDUPLICATOR | x | x | - |
| DIMENSION | ? | ||
| EXPAND_OBJECT | |||
| EXPRESSION | x | x | EXPRESSION |
| EXTERNAL_TABLE | x | x | |
| FILTER | x | x | FILTER_CONDITION |
| FLAT_FILE | ? | ||
| INPUT_PARAMETER | x | x | |
| INPUT_SIGNATURE | |||
| ITERATOROPERATOR | |||
| JOINER | x | x | JOIN_CONDITION |
| KEY_LOOKUP | x | x | |
| LCRCAST | |||
| LCRSPLITTER | |||
| MATCHMERGE | |||
| MATERIALIZED_VIEW | |||
| NAME_AND_ADDRESS | |||
| OUTPUT_PARAMETER | x | x | |
| OUTPUT_SIGNATURE | |||
| PIVOT | x | ||
| PLUGGABLE_MAPPING | ? | ||
| POSTMAPPING_PROCESS | x | ||
| PREMAPPING_PROCESS | x | ||
| SEQUENCE | x | x | |
| SET_OPERATION | x | ||
| SORTER | ? | ||
| SPLITTER | x | x | |
| TABLE | x | x | LOAD_COLUMN_WHEN_INSERTING_ROW, LOAD_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_DELETING_ROW, UPDATE_OPERATION |
| TABLE_FUNCTION | |||
| TRANSFORMATION | x | x | |
| UNPIVOT | x | ||
| VIEW | x | x | LOAD_COLUMN_WHEN_INSERTING_ROW, LOAD_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_DELETING_ROW, UPDATE_OPERATION |
