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 |
No comments:
Post a Comment