Oracle Warehouse Builder - OMB+

OMB+

Script everything.

Use older versions of Oracle documentation

Think lists

OMBCREATE PROJECT 'TEST_PROJECT'; OMBCREATE ORACLE_MODULE 'MOD1'; OMBCREATE MAPPING 'MAP1'; OMBALTER MAPPING 'MAP1' \ ADD TABLE OPERATOR 'EMP_1' \ BOUND TO TABLE '/TEST_PROJECT/SOURCE_MODULE/EMP'; OMBALTER MAPPING 'MAP1' \ ADD CONNECTION \ FROM ATTRIBUTE 'EMPNO' OF GROUP 'INOUTGRP1' OF OPERATOR 'EMP_1' \ TO ATTRIBUTE 'X' OF GROUP 'INOUTGRP1' OF OPERATOR 'DEST_EMP'; set LIST_OF_OPERATORS ; foreach THIS_OPERATOR $LIST_OF_OPERATORS { puts $THIS_OPERATOR; } set LIST_OF_ATTRIBUTES ; foreach THIS_ATTR $LIST_OF_ATTRIBUTES { # Use attribute name from list OMBALTER MAPPING 'MAP1' \ ADD CONNECTION \ FROM ATTRIBUTE '$THIS_ATTR' OF GROUP 'INOUTGRP1' OF OPERATOR 'EMP_1' \ TO ATTRIBUTE '$THIS_ATTR' OF GROUP 'INOUTGRP1' OF OPERATOR 'DEST_EMP'; }