ETL服务器与集群定义数据字典.pdfVIP

1.CX_ETL_SVR_TBL【ETL服务器定义表】

NameTypePhysicalTypeLength说明

ROW_IDSystemVARCHAR215Siebel系统ID

SDB_ETLSVR_IDData(Public)VARCHAR230ETL服务器编号

SDB_ETLSVR_NAMEData(Public)VARCHAR250ETL服务器名称

SDB_EE_FLAGData(Public)VARCHAR24生效失效标志

SDB_ETLSVR_DESCData(Public)VARCHAR2100ETL服务器描述

SDB_ETLSVR_OSData(Public)VARCHAR210ETL服务器操作系统

SDB_ETLSVR_IPData(Public)VARCHAR215ETL服务器IP地址

SDB_ETLSVR_PORTData(Public)VARCHAR25ETL服务器端

SDB_ETLSVR_UNAMEData(Public)VARCHAR230ETL服务器用户名称

SDB_ETLSVR_FPWDData(Public)VARCHAR230ETL服务器用户口令

SDB_ETLSVR_SPWDData(Public)VARCHAR230ETL服务器口令确认

SDB_ETLPRJ_IDData(Public)VARCHAR230ETL项目编号

SDB_ETL_CMDData(Public)VARCHAR2254ETL调度命令行

SDB_ETLSVR_MEMOData(Public)VARCHAR2254备注信息

SIEBEL_OTHER_FIELDSSystemVARCHAR2Siebel其它系统字段

生效失效标志：I失效A生效

2.CX_ETL_JQUN_TBL【ETL集群定义】

NameTypePhysicalTypeLength说明

ROW_IDSystemVARCHAR215Siebel系统ID

SDB_CLUSTER_IDData(Public)VARCHAR230集群编号

SDB_CLUSTER_NAMEData(Public)VARCHAR250集群名称

SDB_DESCR