kettle6.0使用手册

ID_DIRECTORY INTEGER

, ID_DIRECTORY_PARENT INTEGER , DIRECTORY_NAME VARCHAR2(255) , PRIMARY KEY (ID_DIRECTORY) ) ;

CREATE UNIQUE INDEX IDX_RDIR ON R_DIRECTORY(ID_DIRECTORY_PARENT, DIRECTORY_NAME) ;

CREATE TABLE R_TRANSFORMATION (

ID_TRANSFORMATION INTEGER , ID_DIRECTORY INTEGER , NAME VARCHAR2(255) , DESCRIPTION CLOB

, EXTENDED_DESCRIPTION CLOB , TRANS_VERSION VARCHAR2(255) , TRANS_STATUS INTEGER , ID_STEP_READ INTEGER , ID_STEP_WRITE INTEGER , ID_STEP_INPUT INTEGER , ID_STEP_OUTPUT INTEGER , ID_STEP_UPDATE INTEGER , ID_DATABASE_LOG INTEGER , TABLE_NAME_LOG VARCHAR2(255) , USE_BATCHID CHAR(1) , USE_LOGFIELD CHAR(1)

, ID_DATABASE_MAXDATE INTEGER , TABLE_NAME_MAXDATE VARCHAR2(255) , FIELD_NAME_MAXDATE VARCHAR2(255) , OFFSET_MAXDATE NUMBER(12, 2) , DIFF_MAXDATE NUMBER(12, 2) , CREATED_USER VARCHAR2(255) , CREATED_DATE DATE

, MODIFIED_USER VARCHAR2(255) , MODIFIED_DATE DATE , SIZE_ROWSET INTEGER

, PRIMARY KEY (ID_TRANSFORMATION) ) ;

CREATE TABLE R_TRANS_ATTRIBUTE

(

ID_TRANS_ATTRIBUTE INTEGER , ID_TRANSFORMATION INTEGER , NR INTEGER

, CODE VARCHAR2(255) , VALUE_NUM INTEGER , VALUE_STR CLOB

, PRIMARY KEY (ID_TRANS_ATTRIBUTE) ) ;

CREATE UNIQUE INDEX IDX_TATT ON R_TRANS_ATTRIBUTE(ID_TRANSFORMATION, CODE, NR) ;

CREATE TABLE R_JOB_ATTRIBUTE (

ID_JOB_ATTRIBUTE INTEGER , ID_JOB INTEGER , NR INTEGER

, CODE VARCHAR2(255) , VALUE_NUM INTEGER , VALUE_STR CLOB

, PRIMARY KEY (ID_JOB_ATTRIBUTE) ) ;

CREATE UNIQUE INDEX IDX_JATT ON R_JOB_ATTRIBUTE(ID_JOB, CODE, NR) ;

CREATE TABLE R_DEPENDENCY (

ID_DEPENDENCY INTEGER , ID_TRANSFORMATION INTEGER , ID_DATABASE INTEGER , TABLE_NAME VARCHAR2(255) , FIELD_NAME VARCHAR2(255) , PRIMARY KEY (ID_DEPENDENCY) ) ;

CREATE TABLE R_PARTITION_SCHEMA (

ID_PARTITION_SCHEMA INTEGER , NAME VARCHAR2(255)

, DYNAMIC_DEFINITION CHAR(1)

, PARTITIONS_PER_SLAVE VARCHAR2(255) , PRIMARY KEY (ID_PARTITION_SCHEMA) ) ;

CREATE TABLE R_PARTITION (

ID_PARTITION INTEGER

, ID_PARTITION_SCHEMA INTEGER , PARTITION_ID VARCHAR2(255) , PRIMARY KEY (ID_PARTITION) ) ;

CREATE TABLE R_TRANS_PARTITION_SCHEMA (

ID_TRANS_PARTITION_SCHEMA INTEGER , ID_TRANSFORMATION INTEGER , ID_PARTITION_SCHEMA INTEGER

, PRIMARY KEY (ID_TRANS_PARTITION_SCHEMA) ) ;

CREATE TABLE R_CLUSTER (

ID_CLUSTER INTEGER , NAME VARCHAR2(255) , BASE_PORT VARCHAR2(255)

, SOCKETS_BUFFER_SIZE VARCHAR2(255) , SOCKETS_FLUSH_INTERVAL VARCHAR2(255) , SOCKETS_COMPRESSED CHAR(1) , DYNAMIC_CLUSTER CHAR(1) , PRIMARY KEY (ID_CLUSTER) ) ;

CREATE TABLE R_SLAVE (

ID_SLAVE INTEGER , NAME VARCHAR2(255) , HOST_NAME VARCHAR2(255) , PORT VARCHAR2(255)

, WEB_APP_NAME VARCHAR2(255)

, USERNAME VARCHAR2(255) , PASSWORD VARCHAR2(255)

, PROXY_HOST_NAME VARCHAR2(255) , PROXY_PORT VARCHAR2(255) , NON_PROXY_HOSTS VARCHAR2(255) , MASTER CHAR(1)

, PRIMARY KEY (ID_SLAVE) ) ;

CREATE TABLE R_CLUSTER_SLAVE (

ID_CLUSTER_SLAVE INTEGER , ID_CLUSTER INTEGER , ID_SLAVE INTEGER

, PRIMARY KEY (ID_CLUSTER_SLAVE) ) ;

CREATE TABLE R_TRANS_SLAVE (

ID_TRANS_SLAVE INTEGER , ID_TRANSFORMATION INTEGER , ID_SLAVE INTEGER

, PRIMARY KEY (ID_TRANS_SLAVE) ) ;

CREATE TABLE R_TRANS_CLUSTER (

ID_TRANS_CLUSTER INTEGER , ID_TRANSFORMATION INTEGER , ID_CLUSTER INTEGER

, PRIMARY KEY (ID_TRANS_CLUSTER) ) ;

CREATE TABLE R_TRANS_HOP (

ID_TRANS_HOP INTEGER , ID_TRANSFORMATION INTEGER , ID_STEP_FROM INTEGER , ID_STEP_TO INTEGER , ENABLED CHAR(1)