spec-source | filter | source | target | datatype | function · value | ext
--- | --- | --- | --- | --- | --- | ---
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.SCRIPT_CATEGORY | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY · #1 |  | DDL | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.OBJECT_TYPE | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE · #1 |  | TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.SCRIPT_NAME | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME · #1 |  | CREATE_TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.SCRIPT_SEQUENCE | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE · #1 |  | 10 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.SCRIPT_TEXT | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #1 |  | CREATE TABLE <<TARGET_OWNER>>.<<TARGET_NAME>> ( | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.IS_LOOP | OWNER_MBI.MBI_SCRIPT.IS_LOOP · #1 |  | N | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.1.INDENT_LEVEL | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL · #1 |  | 0 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=1schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.SCRIPT_CATEGORY | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY · #2 |  | DDL | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.OBJECT_TYPE | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE · #2 |  | TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.SCRIPT_NAME | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME · #2 |  | CREATE_TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.SCRIPT_SEQUENCE | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE · #2 |  | 20 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.SCRIPT_TEXT | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #2 |  | <<COLUMN_NAME>> <<COLUMN_DATATYPE>><<NULL_CLAUSE>> | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.IS_LOOP | OWNER_MBI.MBI_SCRIPT.IS_LOOP · #2 |  | Y | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.LOOP_DELIMITER | OWNER_MBI.MBI_SCRIPT.LOOP_DELIMITER · #2 |  | , | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.2.INDENT_LEVEL | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL · #2 |  | 2 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=2schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.SCRIPT_CATEGORY | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY · #3 |  | DDL | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.OBJECT_TYPE | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE · #3 |  | TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.SCRIPT_NAME | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME · #3 |  | CREATE_TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.SCRIPT_SEQUENCE | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE · #3 |  | 30 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.SCRIPT_TEXT | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #3 |  | ,CONSTRAINT pk_<<TARGET_NAME>> PRIMARY KEY (<<PRIMARY_KEY_COLS>>) | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.IS_LOOP | OWNER_MBI.MBI_SCRIPT.IS_LOOP · #3 |  | N | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.INDENT_LEVEL | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL · #3 |  | 2 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.3.CONDITION_TOKEN | OWNER_MBI.MBI_SCRIPT.CONDITION_TOKEN · #3 |  | <<HAS_PRIMARY_KEY>> | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=3schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.SCRIPT_CATEGORY | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY · #4 |  | DDL | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.OBJECT_TYPE | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE · #4 |  | TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.SCRIPT_NAME | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME · #4 |  | CREATE_TABLE | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.SCRIPT_SEQUENCE | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE · #4 |  | 40 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.SCRIPT_TEXT | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #4 |  | ); | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.IS_LOOP | OWNER_MBI.MBI_SCRIPT.IS_LOOP · #4 |  | N | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
data-block | d | HC.dt-MBI_SCRIPT-rows-CREATE_TABLE.row.4.INDENT_LEVEL | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL · #4 |  | 0 | block-id=dt-MBI_SCRIPT-rows-CREATE_TABLEdata-row-id=4schema-ref=OWNER_META.TABLE_SPECIFICATIONS#ts-MBI_SCRIPT
process-block | p | HC.pr-bounded-dispatch.step.1.invokes | OWNER_MEMEROOT.BOUNDED_DISPATCH.STEP.read-metadata · #1 |  | schema-block@OWNER_META.TABLE_SPECIFICATIONS | block-id=pr-bounded-dispatchstep-seq=1step-name=read-metadatainvokes-kind=schema-blockinvokes-address=OWNER_META.TABLE_SPECIFICATIONS
process-block | p | HC.pr-bounded-dispatch.step.1.invokes | OWNER_MEMEROOT.BOUNDED_DISPATCH.STEP.read-metadata · #1 |  | schema-block@OWNER_MBI.MBI_SCRIPT | block-id=pr-bounded-dispatchstep-seq=1step-name=read-metadatainvokes-kind=schema-blockinvokes-address=OWNER_MBI.MBI_SCRIPT
process-block | p | HC.pr-bounded-dispatch.step.2.invokes | OWNER_MEMEROOT.BOUNDED_DISPATCH.STEP.generate-artifact · #2 |  | template-block@OWNER_MBI.CREATE_TABLE | block-id=pr-bounded-dispatchstep-seq=2step-name=generate-artifactinvokes-kind=template-blockinvokes-address=OWNER_MBI.CREATE_TABLE
process-block | p | HC.pr-bounded-dispatch.step.3.invokes | OWNER_MEMEROOT.BOUNDED_DISPATCH.STEP.dispatch-bounded · #3 |  | script-block@EDW_CLC.pmexecutequery | block-id=pr-bounded-dispatchstep-seq=3step-name=dispatch-boundedinvokes-kind=script-blockinvokes-address=EDW_CLC.pmexecutequery
process-block | p | HC.pr-bounded-dispatch.step.4.invokes | OWNER_MEMEROOT.BOUNDED_DISPATCH.STEP.audit-emit · #4 |  | script-block@OWNER_AUDIT.append-blockchain-table | block-id=pr-bounded-dispatchstep-seq=4step-name=audit-emitinvokes-kind=script-blockinvokes-address=OWNER_AUDIT.append-blockchain-table
schema-block | i | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY | OWNER_MBI.MBI_SCRIPT.SCRIPT_CATEGORY · #1 pk | VARCHAR2(50) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE | OWNER_MBI.MBI_SCRIPT.OBJECT_TYPE · #2 pk | VARCHAR2(50) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME | OWNER_MBI.MBI_SCRIPT.SCRIPT_NAME · #3 pk | VARCHAR2(100) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE | OWNER_MBI.MBI_SCRIPT.SCRIPT_SEQUENCE · #4 pk | NUMBER |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #5 | VARCHAR2(4000) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.IS_LOOP | OWNER_MBI.MBI_SCRIPT.IS_LOOP · #6 | VARCHAR2(1) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.LOOP_DELIMITER | OWNER_MBI.MBI_SCRIPT.LOOP_DELIMITER · #7 | VARCHAR2(20) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL | OWNER_MBI.MBI_SCRIPT.INDENT_LEVEL · #8 | NUMBER |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_MBI.MBI_SCRIPT.CONDITION_TOKEN | OWNER_MBI.MBI_SCRIPT.CONDITION_TOKEN · #9 | VARCHAR2(100) |  | block-id=ts-MBI_SCRIPT
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_OWNER | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_OWNER · #1 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_NAME | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_NAME · #2 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_ATTRIBUTE | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_ATTRIBUTE · #3 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_DATATYPE | OWNER_META.TABLE_SPECIFICATIONS.SOURCE_DATATYPE · #4 | VARCHAR2(200) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_OWNER | OWNER_META.TABLE_SPECIFICATIONS.TARGET_OWNER · #5 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_NAME | OWNER_META.TABLE_SPECIFICATIONS.TARGET_NAME · #6 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_PREFIX | OWNER_META.TABLE_SPECIFICATIONS.TARGET_PREFIX · #7 | VARCHAR2(20) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_ATTRIBUTE | OWNER_META.TABLE_SPECIFICATIONS.TARGET_ATTRIBUTE · #8 pk | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_FUNCTION | OWNER_META.TABLE_SPECIFICATIONS.TARGET_FUNCTION · #9 | VARCHAR2(4000) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_ID | OWNER_META.TABLE_SPECIFICATIONS.TARGET_ID · #10 | NUMBER |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.INDEX_TYPE | OWNER_META.TABLE_SPECIFICATIONS.INDEX_TYPE · #11 | VARCHAR2(10) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_NULL | OWNER_META.TABLE_SPECIFICATIONS.TARGET_NULL · #12 | VARCHAR2(1) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_DATATYPE | OWNER_META.TABLE_SPECIFICATIONS.TARGET_DATATYPE · #13 | VARCHAR2(200) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.TARGET_DEFAULT | OWNER_META.TABLE_SPECIFICATIONS.TARGET_DEFAULT · #14 | VARCHAR2(200) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.AGGREGATE | OWNER_META.TABLE_SPECIFICATIONS.AGGREGATE · #15 | VARCHAR2(50) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.FILTER_FLAG | OWNER_META.TABLE_SPECIFICATIONS.FILTER_FLAG · #16 | VARCHAR2(1) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.CONDITION | OWNER_META.TABLE_SPECIFICATIONS.CONDITION · #17 | VARCHAR2(200) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.JOIN_CONDITION | OWNER_META.TABLE_SPECIFICATIONS.JOIN_CONDITION · #18 | VARCHAR2(400) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.VIEW_OWNER | OWNER_META.TABLE_SPECIFICATIONS.VIEW_OWNER · #19 | VARCHAR2(128) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.VIEW_FILTER | OWNER_META.TABLE_SPECIFICATIONS.VIEW_FILTER · #20 | VARCHAR2(400) |  | block-id=ts-TABLE_SPECIFICATIONS
schema-block | i | OWNER_META.TABLE_SPECIFICATIONS.VIEW_PREFIX | OWNER_META.TABLE_SPECIFICATIONS.VIEW_PREFIX · #21 | VARCHAR2(20) |  | block-id=ts-TABLE_SPECIFICATIONS
script-block | S | HC.sc-exe_var_deletefolder.exe_var_deletefolder.BODY | EDW_CLC.exe_var_deletefolder.SCRIPT_BODY · #0 | ksh | #!/usr/bin/ksh if [ -d "$1" ]; then print "Deleting folder: $1" rm -rf "$1" print "COMPLETED" else print "Folder does not exist: $1" exit 1 fi | block-id=sc-exe_var_deletefolderscript-language=kshscript-runtime=POSIX shellscript-author=Robert Andersonscript-created=
script-block | i | HC.sc-exe_var_deletefolder.parameter.1 | EDW_CLC.exe_var_deletefolder.INPUT.folder_path · #1 | path |  | block-id=sc-exe_var_deletefolderparameter-position=1parameter-allowed=
script-block | S | HC.sc-pmexecutequery.pmexecutequery.BODY | EDW_CLC.pmexecutequery.SCRIPT_BODY · #0 | ksh | #!/usr/bin/ksh print "query name = "$1 print "Process type = "$2 print "\n===============================================================================" print " Start Informatica query ($1): $(date +"%d-%b-%Y %H:%M:%S")" print "=================================================================================\n" print "\nEXECUTING COMMAND => pmrep connect -r RS_SNI_DV2 -d $INFA_DEFAULT_DOMAIN -n $PM_USERNAME -x $PM_PASSWORD " pmrep connect -r RS_SNI_DV2 -d $INFA_DEFAULT_DOMAIN -n $PM_USERNAME -x $PM_PASSWORD print "\nEXECUTING COMMAND => pmrep executequery -q $1 -t Shared -u $1_output.txt " pmrep executequery -q $1 -t Shared -u $1_output.txt if [ $2 = "validate" ] then print "\nEXECUTING COMMAND => pmrep validate -i $1_output.txt -s -k -m Validated" pmrep validate -i $1_output.txt -s -k -m Validated fi print "\nCOMPLETED" | block-id=sc-pmexecutequeryscript-language=kshscript-runtime=POSIX shell + Informatica pmrep CLIscript-author=Robert Andersonscript-created=2017-05-11
script-block | i | HC.sc-pmexecutequery.parameter.1 | EDW_CLC.pmexecutequery.INPUT.query_name · #1 | string |  | block-id=sc-pmexecutequeryparameter-position=1parameter-allowed=
script-block | i | HC.sc-pmexecutequery.parameter.2 | EDW_CLC.pmexecutequery.INPUT.process_type · #2 | enum |  | block-id=sc-pmexecutequeryparameter-position=2parameter-allowed=validate
template-block | S | HC.MBI_SCRIPT.DDL.TABLE.CREATE_TABLE.0010 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0010 | VARCHAR2(4000) | CREATE TABLE <<TARGET_OWNER>>.<<TARGET_NAME>> ( | block-id=tp-CREATE_TABLEcategory=DDLobject-type=TABLEscript-name=CREATE_TABLEsequence=0010is-loop=Nloop-delimiter=indent-level=0condition-token=
template-block | S | HC.MBI_SCRIPT.DDL.VIEW.GEN_LPV_TRANS_FEAT.0010 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0010 | VARCHAR2(4000) | create or replace view EDW_CLC_LDR.<<TARGET_VIEW_NAME>> as select | block-id=tp-GEN_LPV_TRANS_FEATcategory=DDLobject-type=VIEWscript-name=GEN_LPV_TRANS_FEATsequence=0010is-loop=Nloop-delimiter=indent-level=0condition-token=
template-block | L | HC.MBI_SCRIPT.DDL.TABLE.CREATE_TABLE.0020 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0020 | VARCHAR2(4000) | <<COLUMN_NAME>> <<COLUMN_DATATYPE>><<NULL_CLAUSE>> | block-id=tp-CREATE_TABLEcategory=DDLobject-type=TABLEscript-name=CREATE_TABLEsequence=0020is-loop=Yloop-delimiter=, indent-level=2condition-token=
template-block | S | HC.MBI_SCRIPT.DDL.VIEW.GEN_LPV_TRANS_FEAT.0020 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0020 | VARCHAR2(4000) | <<TARGET_KEY>> <<ATTRIBUTES>> | block-id=tp-GEN_LPV_TRANS_FEATcategory=DDLobject-type=VIEWscript-name=GEN_LPV_TRANS_FEATsequence=0020is-loop=Nloop-delimiter=indent-level=2condition-token=
template-block | S | HC.MBI_SCRIPT.DDL.TABLE.CREATE_TABLE.0030 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0030 | VARCHAR2(4000) | ,CONSTRAINT pk_<<TARGET_NAME>> PRIMARY KEY (<<PRIMARY_KEY_COLS>>) | block-id=tp-CREATE_TABLEcategory=DDLobject-type=TABLEscript-name=CREATE_TABLEsequence=0030is-loop=Nloop-delimiter=indent-level=2condition-token=<<HAS_PRIMARY_KEY>>
template-block | S | HC.MBI_SCRIPT.DDL.VIEW.GEN_LPV_TRANS_FEAT.0030 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0030 | VARCHAR2(4000) | from <<OWNER_NAME>>.<<SOURCE_VIEW_NAME>>; | block-id=tp-GEN_LPV_TRANS_FEATcategory=DDLobject-type=VIEWscript-name=GEN_LPV_TRANS_FEATsequence=0030is-loop=Nloop-delimiter=indent-level=0condition-token=
template-block | S | HC.MBI_SCRIPT.DDL.TABLE.CREATE_TABLE.0040 | OWNER_MBI.MBI_SCRIPT.SCRIPT_TEXT · #0040 | VARCHAR2(4000) | ); | block-id=tp-CREATE_TABLEcategory=DDLobject-type=TABLEscript-name=CREATE_TABLEsequence=0040is-loop=Nloop-delimiter=indent-level=0condition-token=