Tuesday, June 29, 2010

Generate mapping creation tcl script

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

Operator typePlaned to implementImplementedProcessed operator properties
ADVANCED_QUEUE
AGGREGATORxxGROUP_BY_CLAUSE, HAVING_CLAUSE
ANYDATA_CAST
CONSTANTxxEXPRESSION
CONSTRUCT_OBJECT
CUBE?
DATA_GENERATOR
DEDUPLICATORxx-
DIMENSION?
EXPAND_OBJECT
EXPRESSIONxxEXPRESSION
EXTERNAL_TABLExx
FILTERxxFILTER_CONDITION
FLAT_FILE?
INPUT_PARAMETERxx
INPUT_SIGNATURE
ITERATOROPERATOR
JOINERxxJOIN_CONDITION
KEY_LOOKUPxx
LCRCAST
LCRSPLITTER
MATCHMERGE
MATERIALIZED_VIEW
NAME_AND_ADDRESS
OUTPUT_PARAMETERxx
OUTPUT_SIGNATURE
PIVOTx
PLUGGABLE_MAPPING?
POSTMAPPING_PROCESSx
PREMAPPING_PROCESSx
SEQUENCExx
SET_OPERATIONx
SORTER?
SPLITTERxx
TABLExxLOAD_COLUMN_WHEN_INSERTING_ROW, LOAD_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_DELETING_ROW, UPDATE_OPERATION
TABLE_FUNCTION
TRANSFORMATIONxx
UNPIVOTx
VIEWxxLOAD_COLUMN_WHEN_INSERTING_ROW, LOAD_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_UPDATING_ROW, MATCH_COLUMN_WHEN_DELETING_ROW, UPDATE_OPERATION