The spine.

DDL

TABLE

CREATE_TABLE

10

CREATE TABLE <<TARGET_OWNER>>.<<TARGET_NAME>> (

N

0

DDL

TABLE

CREATE_TABLE

20

<<COLUMN_NAME>> <<COLUMN_DATATYPE>><<NULL_CLAUSE>>

Y

,

2

DDL

TABLE

CREATE_TABLE

30

,CONSTRAINT pk_<<TARGET_NAME>> PRIMARY KEY (<<PRIMARY_KEY_COLS>>)

N

2

<<HAS_PRIMARY_KEY>>

DDL

TABLE

CREATE_TABLE

40

);

N

0

schema-block@OWNER_META.TABLE_SPECIFICATIONS

schema-block@OWNER_MBI.MBI_SCRIPT

template-block@OWNER_MBI.CREATE_TABLE

script-block@EDW_CLC.pmexecutequery

script-block@OWNER_AUDIT.append-blockchain-table

#!/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

#!/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"

CREATE TABLE <<TARGET_OWNER>>.<<TARGET_NAME>> (

create or replace view EDW_CLC_LDR.<<TARGET_VIEW_NAME>> as select

<<COLUMN_NAME>> <<COLUMN_DATATYPE>><<NULL_CLAUSE>>

<<TARGET_KEY>> <<ATTRIBUTES>>

,CONSTRAINT pk_<<TARGET_NAME>> PRIMARY KEY (<<PRIMARY_KEY_COLS>>)

from <<OWNER_NAME>>.<<SOURCE_VIEW_NAME>>;

);