问题一:
ODBC_Connector_21: Schema reconciliation detected a size mismatch for column longdrive_time. When reading database column DFLOAT into column SFLOAT, truncation, loss of precision, data corruption or padding can occur. (CC_DBSchemaRules::reportSizeMismatch, file CC_DBSchemaRules.cpp, line 1,768)
解决方法:源输入的column longdrive_time 精度转换为sfloat, 源数据库转换数据类型的函数为flat4() 降低精度
问题二:
Transformer_2: Error when checking operator: Could not find input field "longdrive_time".
解决方法:抽取数据的控件中,1,缺该字段 2,字段命名和column列表中的字段名不一致
问题三:
ODBC_Connector_21,0: Execution failed on statement
解决方法:该控件中的SQL语法有错误
问题4:oracle_dwstage,0: The OCI function OCIStmtExecute returned status 1. Error code: 12899, Error message: ORA-12899: value too large for column."DEALER_TELE_NUMBER" (actual: 46, maximum: 40).
实际源与目标用的类型是一样 的