Created by Miki Yanagi, last modified on Sep 24, 2019
Generated documentation
Jobs
Generated by Talend Open Studio for Data Integration


Project NameFN_StagingGENERATION DATEAug 26, 2019 10:00:40 AM
AUTHORuser@talend.comTalend Open Studio VERSION 7.1.1.20181026_1147

Summary

Project Description
Description
Preview Picture
Settings
Context List
Component List
Components Description


Project Description


PropertiesValues
NameFN_Staging
Languagejava
Description


Description


PropertiesValues
NameFNS03_UM_GLQ_ACCTA
Authoruser@talend.com
Version1.0
PurposeLoads the UM_GLQ_ACCTA data from PS to FN
StatusDEV
DescriptionLoads the UM_GLQ_ACCTA data from PeopleSoft to SQL Server Staging.
CreationJun 3, 2019 8:46:52 AM
ModificationAug 26, 2019 9:11:40 AM

Preview Picture


No image available
tBufferOutput_1tDBInput_2tDBInput_6tDBOutput_2tDBOutput_3tDBOutput_4tDie_1tFixedFlowInput_1tFlowMeter_9tJavaRow_4tJava_2tJava_3tLogCatcher_1tMap_1tMap_2tMap_3tMap_7tSendMail_1tSetGlobalVar_1

Settings

Extra settings

NameValue
COMP_DEFAULT_FILE_DIR
Multi thread executiontrue
Implicit tContextLoadfalse


Status & Logs

NameValue
Use statistics (tStatCatcher)true
Use logs (tLogCatcher)false
Use volumetrics (tFlowMeterCatcher)true
On Consoletrue
On Filesfalse
On Databasestrue
Property Type
PropertyREPOSITORY
Property:sourceDI_CNTL
Db TypetMSSqlOutput
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Db Name context.DI_CNTL_Database
Additional parameterscontext.DI_CNTL_AdditionalParams
Schemacontext.DI_CNTL_Schema
Usercontext.DI_CNTL_Login
Password ************************
Datasource""
Logs Table"cntl_logCatcher"
Meter Table"cntl_flowMeter"
Stats Table"cntl_statCatcher"
Catch components statisticstrue
Catch runtime errorstrue
Catch user errorstrue
Catch user warningstrue


Context List

ContextDefault

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringDI_CNTLDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringsaDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_StringlocalhostDI_CNTL_Context
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringTalendStagingSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringsaSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password********SS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_StringlocalhostSS_Staging_Context
SSI_Context_SchemaSSI_Context_Schema?falseid_StringdboSS_INTEGRATION_Context
SSI_Context_AdditionalParamsSSI_Context_AdditionalParams?falseid_StringSS_INTEGRATION_Context
SSI_Context_LoginSSI_Context_Login?falseid_StringsaSS_INTEGRATION_Context
SSI_Context_ServerSSI_Context_Server?falseid_StringlocalhostSS_INTEGRATION_Context
SSI_Context_PortSSI_Context_Port?falseid_String1433SS_INTEGRATION_Context
SSI_Context_PasswordSSI_Context_Password?falseid_Password********************************SS_INTEGRATION_Context
SSI_Context_DatabaseSSI_Context_Database?falseid_StringTalendTestSS_INTEGRATION_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2020FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextDEV

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_DEVDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_DEVSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
SSI_Context_SchemaSSI_Context_Schema?falseid_StringdboSS_INTEGRATION_Context
SSI_Context_AdditionalParamsSSI_Context_AdditionalParams?falseid_StringSS_INTEGRATION_Context
SSI_Context_LoginSSI_Context_Login?falseid_StringPS_TO_DMSS_INTEGRATION_Context
SSI_Context_ServerSSI_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_INTEGRATION_Context
SSI_Context_PortSSI_Context_Port?falseid_String1433SS_INTEGRATION_Context
SSI_Context_PasswordSSI_Context_Password?falseid_Password**********SS_INTEGRATION_Context
SSI_Context_DatabaseSSI_Context_Database?falseid_StringUMS_INTEGRATION_DEVSS_INTEGRATION_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextFNPRD

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_DEVDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringTalendStagingSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringsaSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password********SS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_StringlocalhostSS_Staging_Context
SSI_Context_SchemaSSI_Context_Schema?falseid_StringdboSS_INTEGRATION_Context
SSI_Context_AdditionalParamsSSI_Context_AdditionalParams?falseid_StringSS_INTEGRATION_Context
SSI_Context_LoginSSI_Context_Login?falseid_StringsaSS_INTEGRATION_Context
SSI_Context_ServerSSI_Context_Server?falseid_StringlocalhostSS_INTEGRATION_Context
SSI_Context_PortSSI_Context_Port?falseid_String1433SS_INTEGRATION_Context
SSI_Context_PasswordSSI_Context_Password?falseid_Password********************************SS_INTEGRATION_Context
SSI_Context_DatabaseSSI_Context_Database?falseid_StringTalendTestSS_INTEGRATION_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu;tsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2020FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextPRD

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_PRDDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServerFNContext_Server?falseid_Stringfnprd.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNPRDFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_PRDSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
SSI_Context_SchemaSSI_Context_Schema?falseid_StringdboSS_INTEGRATION_Context
SSI_Context_AdditionalParamsSSI_Context_AdditionalParams?falseid_StringSS_INTEGRATION_Context
SSI_Context_LoginSSI_Context_Login?falseid_StringPS_TO_DMSS_INTEGRATION_Context
SSI_Context_ServerSSI_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_INTEGRATION_Context
SSI_Context_PortSSI_Context_Port?falseid_String1433SS_INTEGRATION_Context
SSI_Context_PasswordSSI_Context_Password?falseid_Password**********SS_INTEGRATION_Context
SSI_Context_DatabaseSSI_Context_Database?falseid_StringUMS_INTEGRATION_PRDSS_INTEGRATION_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; rachel.groenhout@maine.edu; asgeir.whitney@maine.edu; johns@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; rachel.groenhout@maine.edu; asgeir.whitney@maine.edu; johns@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer180000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts


ContextTST

NamePromptNeed Prompt?TypeValueSource
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_TSTDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_ServerFNContext_Server?falseid_Stringfntst.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNTSTFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_TSTSS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_Context
SSI_Context_SchemaSSI_Context_Schema?falseid_StringdboSS_INTEGRATION_Context
SSI_Context_AdditionalParamsSSI_Context_AdditionalParams?falseid_StringSS_INTEGRATION_Context
SSI_Context_LoginSSI_Context_Login?falseid_StringPS_TO_DMSS_INTEGRATION_Context
SSI_Context_ServerSSI_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_INTEGRATION_Context
SSI_Context_PortSSI_Context_Port?falseid_String1433SS_INTEGRATION_Context
SSI_Context_PasswordSSI_Context_Password?falseid_Password**********SS_INTEGRATION_Context
SSI_Context_DatabaseSSI_Context_Database?falseid_StringUMS_INTEGRATION_TSTSS_INTEGRATION_Context
tsendMailUsernametsendMailUsername?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailPasswordtsendMailPassword?falseid_Password****tsendMail_Context
tsendMailCctsendMailCc?falseid_StringnulltsendMail_Context
tsendMailSMTPPorttsendMailSMTPPort?falseid_String465tsendMail_Context
tsendMailSubject_FailuretsendMailSubject_Failure?falseid_String"*** ERROR *** Talend Job " +((String)globalMap.get("vErrorJob")) +" (" +((String)globalMap.get("vErrorJobPID")) +") *** Failed ***"tsendMail_Context
tsendMailToFailuretsendMailToFailure?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailMessage_FailuretsendMailMessage_Failure?falseid_StringtsendMail_Context
tsendMailSMTPHosttsendMailSMTPHost?falseid_Stringsmarthost.maine.edutsendMail_Context
tsendMailToSuccesstsendMailToSuccess?falseid_Stringjeffrey.jensen@maine.edu; miki.yanagi@maine.edu; pavan.narayanan@maine.edu; asgeir.whitney@maine.edu; gary.blake@maine.edutsendMail_Context
tsendMailSubjecttsendMailSubject?falseid_StringtsendMail_Context
tsendMailMessagetsendMailMessage?falseid_StringtsendMail_Context
tsendMailSubject_SuccesstsendMailSubject_Success?falseid_StringtsendMail_Context
tsendMailFromtsendMailFrom?falseid_StringDARTS@maine.edutsendMail_Context
tsendMailBcctsendMailBcc?falseid_StringnulltsendMail_Context
tsendMailMessage_SuccesstsendMailMessage_Success?falseid_StringtsendMail_Context
FY_StartFY_Start?falseid_Integer2006FN_Specific_Contexts
FY_EndFY_End?falseid_Integer9999FN_Specific_Contexts
TGT_Schema_8TGT_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_9TGT_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_2TGT_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_3TGT_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_1TGT_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_6TGT_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_7TGT_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_4TGT_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_5TGT_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsTotal_10TGT_RowsTotal_10?falseid_Integer0General_Job_Contexts
TGT_SOR_SK_10TGT_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsUpdated_10TGT_RowsUpdated_10?falseid_Integer0General_Job_Contexts
TGT_TableName_9TGT_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_8TGT_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_5TGT_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_4TGT_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_7TGT_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_6TGT_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
ThreadTimeThreadTime?falseid_Integer3000General_Job_Contexts
TGT_TableRowCount_Before_1TGT_TableRowCount_Before_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_2TGT_TableRowCount_Before_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_3TGT_TableRowCount_Before_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_4TGT_TableRowCount_Before_4?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_5TGT_TableRowCount_Before_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_6TGT_TableRowCount_Before_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_7TGT_TableRowCount_Before_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_8TGT_TableRowCount_Before_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_Before_9TGT_TableRowCount_Before_9?falseid_Integer0General_Job_Contexts
SRC_Table_DI_Purpose_10SRC_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_1TGT_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_3TGT_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_2TGT_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_10TGT_RowsRejected_10?falseid_Integer0General_Job_Contexts
SRC_Schema_10SRC_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_3SRC_Query_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_2SRC_Query_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_1TGT_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_5SRC_Query_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_4SRC_Query_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_7SRC_Query_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_4TGT_Database_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_6SRC_Query_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_5TGT_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_9SRC_Query_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_2TGT_Database_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_8SRC_Query_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_3TGT_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_8TGT_Database_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_9TGT_Database_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_6TGT_Database_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Database_7TGT_Database_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_10SRC_Table_No_10?falseid_Integer1General_Job_Contexts
TGT_Table_DI_Purpose_10TGT_Table_DI_Purpose_10?falseid_StringDefaultGeneral_Job_Contexts
LoopCounterLoopCounter?falseid_Integer0General_Job_Contexts
SRC_Query_1SRC_Query_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_8TGT_RowsInserted_8?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_9TGT_RowsInserted_9?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_6TGT_RowsInserted_6?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_7TGT_RowsInserted_7?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_4TGT_RowsInserted_4?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_5TGT_RowsInserted_5?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_2TGT_RowsInserted_2?falseid_Integer0General_Job_Contexts
TGT_RowsInserted_3TGT_RowsInserted_3?falseid_Integer0General_Job_Contexts
SRC_TableName_10SRC_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableName_10TGT_TableName_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsInserted_1TGT_RowsInserted_1?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_2TGT_RowsRejected_2?falseid_Integer0General_Job_Contexts
TGT_Server_10TGT_Server_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_3TGT_RowsRejected_3?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_4TGT_RowsRejected_4?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_5TGT_RowsRejected_5?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_6TGT_RowsRejected_6?falseid_Integer0General_Job_Contexts
TGT_Database_10TGT_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsRejected_7TGT_RowsRejected_7?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_8TGT_RowsRejected_8?falseid_Integer0General_Job_Contexts
TGT_RowsRejected_9TGT_RowsRejected_9?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_10SRC_TableRowCount_10?falseid_Integer0General_Job_Contexts
SRC_Table_No_1SRC_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_RowsRejected_1TGT_RowsRejected_1?falseid_Integer0General_Job_Contexts
ContinueLoopContinueLoop?falseid_BooleanfalseGeneral_Job_Contexts
TGT_SOR_SK_2TGT_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_3TGT_SOR_SK_3?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_1TGT_SOR_SK_1?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_6TGT_SOR_SK_6?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_7TGT_SOR_SK_7?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_4TGT_SOR_SK_4?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_5TGT_SOR_SK_5?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_8TGT_SOR_SK_8?falseid_Integer1General_Job_Contexts
TGT_SOR_SK_9TGT_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_Server_6SRC_Server_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_3SRC_Table_No_3?falseid_Integer1General_Job_Contexts
SRC_Server_5SRC_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_2SRC_Table_No_2?falseid_Integer1General_Job_Contexts
SRC_Server_8SRC_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_5SRC_Table_No_5?falseid_Integer1General_Job_Contexts
SRC_Server_7SRC_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_4SRC_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_Server_2SRC_Server_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_7SRC_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Server_1SRC_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_6SRC_Table_No_6?falseid_Integer1General_Job_Contexts
SRC_Server_4SRC_Server_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_9SRC_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Server_3SRC_Server_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_No_8SRC_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Server_9SRC_Server_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_SOR_SK_10SRC_SOR_SK_10?falseid_Integer1General_Job_Contexts
TGT_RowsInserted_10TGT_RowsInserted_10?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_8TGT_RowsUpdated_8?falseid_Integer0General_Job_Contexts
SRC_Database_10SRC_Database_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_7TGT_RowsUpdated_7?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_9TGT_RowsUpdated_9?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_4TGT_RowsUpdated_4?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_3TGT_RowsUpdated_3?falseid_Integer0General_Job_Contexts
SRC_TableName_9SRC_TableName_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_6TGT_RowsUpdated_6?falseid_Integer0General_Job_Contexts
TGT_RowsUpdated_5TGT_RowsUpdated_5?falseid_Integer0General_Job_Contexts
SRC_TableName_7SRC_TableName_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_8SRC_TableName_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_5SRC_TableName_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_2TGT_RowsUpdated_2?falseid_Integer0General_Job_Contexts
SRC_TableName_6SRC_TableName_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsUpdated_1TGT_RowsUpdated_1?falseid_Integer0General_Job_Contexts
SRC_TableName_3SRC_TableName_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_4SRC_TableName_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Schema_10TGT_Schema_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_1SRC_TableName_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_TableName_2SRC_TableName_2?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_9SRC_Database_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_2SRC_Database_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_9TGT_Table_No_9?falseid_Integer1General_Job_Contexts
SRC_Database_1SRC_Database_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_4SRC_Database_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_7TGT_Table_No_7?falseid_Integer1General_Job_Contexts
SRC_Database_3SRC_Database_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_8TGT_Table_No_8?falseid_Integer1General_Job_Contexts
SRC_Database_6SRC_Database_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_5SRC_Database_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_8SRC_Database_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Database_7SRC_Database_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_No_1TGT_Table_No_1?falseid_Integer1General_Job_Contexts
TGT_Table_No_2TGT_Table_No_2?falseid_Integer1General_Job_Contexts
TGT_Table_No_5TGT_Table_No_5?falseid_Integer1General_Job_Contexts
TGT_Table_No_6TGT_Table_No_6?falseid_Integer1General_Job_Contexts
TGT_Table_No_3TGT_Table_No_3?falseid_Integer1General_Job_Contexts
TGT_Table_No_4TGT_Table_No_4?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_7SRC_SOR_SK_7?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_8SRC_SOR_SK_8?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_9SRC_SOR_SK_9?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_2SRC_TableRowCount_2?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_1SRC_TableRowCount_1?falseid_Integer0General_Job_Contexts
TGT_Table_No_10TGT_Table_No_10?falseid_Integer1General_Job_Contexts
LoopInterationsLoopInterations?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_3SRC_SOR_SK_3?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_4SRC_TableRowCount_4?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_4SRC_SOR_SK_4?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_3SRC_TableRowCount_3?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_5SRC_SOR_SK_5?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_6SRC_TableRowCount_6?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_6SRC_SOR_SK_6?falseid_Integer1General_Job_Contexts
SRC_TableRowCount_5SRC_TableRowCount_5?falseid_Integer0General_Job_Contexts
SRC_SOR_SK_1SRC_SOR_SK_1?falseid_Integer1General_Job_Contexts
SRC_SOR_SK_2SRC_SOR_SK_2?falseid_Integer1General_Job_Contexts
TGT_TableRowCount_After_9TGT_TableRowCount_After_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_5TGT_TableRowCount_After_5?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_6TGT_TableRowCount_After_6?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_7TGT_TableRowCount_After_7?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_8TGT_TableRowCount_After_8?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_1TGT_TableRowCount_After_1?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_2TGT_TableRowCount_After_2?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_3TGT_TableRowCount_After_3?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_4TGT_TableRowCount_After_4?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_8SRC_TableRowCount_8?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_7SRC_TableRowCount_7?falseid_Integer0General_Job_Contexts
SRC_TableRowCount_9SRC_TableRowCount_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_1TGT_RowsTotal_1?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_4TGT_RowsTotal_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_7TGT_RowsDeleted_7?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_5TGT_RowsTotal_5?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_8TGT_RowsDeleted_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_2TGT_RowsTotal_2?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_5TGT_RowsDeleted_5?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_3TGT_RowsTotal_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_6TGT_RowsDeleted_6?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_8TGT_RowsTotal_8?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_9TGT_RowsTotal_9?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_6TGT_RowsTotal_6?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_9TGT_RowsDeleted_9?falseid_Integer0General_Job_Contexts
TGT_TableRowCount_After_10TGT_TableRowCount_After_10?falseid_Integer0General_Job_Contexts
TGT_RowsTotal_7TGT_RowsTotal_7?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_3TGT_RowsDeleted_3?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_4TGT_RowsDeleted_4?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_1TGT_RowsDeleted_1?falseid_Integer0General_Job_Contexts
TGT_RowsDeleted_2TGT_RowsDeleted_2?falseid_Integer0General_Job_Contexts
TGT_Server_2TGT_Server_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_3TGT_Server_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_4TGT_Server_4?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_5TGT_Server_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_8SRC_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_7SRC_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_9SRC_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_1TGT_Server_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_4SRC_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_3SRC_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_6SRC_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_5SRC_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_6TGT_Server_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_7TGT_Server_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_2SRC_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_8TGT_Server_8?falseid_StringDefaultGeneral_Job_Contexts
SRC_Table_DI_Purpose_1SRC_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Server_9TGT_Server_9?falseid_StringDefaultGeneral_Job_Contexts
TGT_TableRowCount_Before_10TGT_TableRowCount_Before_10?falseid_Integer0General_Job_Contexts
SRC_Schema_7SRC_Schema_7?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_8SRC_Schema_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_RowsDeleted_10TGT_RowsDeleted_10?falseid_Integer0General_Job_Contexts
SRC_Schema_9SRC_Schema_9?falseid_StringDefaultGeneral_Job_Contexts
SRC_Server_10SRC_Server_10?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_3SRC_Schema_3?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_4SRC_Schema_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_5SRC_Schema_5?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_6SRC_Schema_6?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_1SRC_Schema_1?falseid_StringDefaultGeneral_Job_Contexts
SRC_Schema_2SRC_Schema_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_1TGT_Table_DI_Purpose_1?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_2TGT_Table_DI_Purpose_2?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_3TGT_Table_DI_Purpose_3?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_4TGT_Table_DI_Purpose_4?falseid_StringDefaultGeneral_Job_Contexts
SRC_Query_10SRC_Query_10?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_5TGT_Table_DI_Purpose_5?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_6TGT_Table_DI_Purpose_6?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_7TGT_Table_DI_Purpose_7?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_8TGT_Table_DI_Purpose_8?falseid_StringDefaultGeneral_Job_Contexts
TGT_Table_DI_Purpose_9TGT_Table_DI_Purpose_9?falseid_StringDefaultGeneral_Job_Contexts




Component List

Component NameComponent Type
tBufferOutput_1tBufferOutput
tDBInput_2tOracleInput
tDBInput_6tMSSqlInput
tDBOutput_2tMSSqlOutput
tDBOutput_3tMSSqlOutput
tDBOutput_4tMSSqlOutput
tDie_1tDie
tFixedFlowInput_1tFixedFlowInput
tFlowMeter_9tFlowMeter
tJavaRow_4tJavaRow
tJava_2tJava
tJava_3tJava
tLogCatcher_1tLogCatcher
tMap_1tMap
tMap_2tMap
tMap_3tMap
tMap_7tMap
tSendMail_1tSendMail
tSetGlobalVar_1tSetGlobalVar

Components Description

Component   tBufferOutput

      UNIQUE NAMEtBufferOutput_1INPUT(S)tMap_2
LABEL__UNIQUE_NAME__OUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametBufferOutput_1
Component NametBufferOutput
Version0.101 (ALPHA)
FamilyMisc
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tBufferOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Label format__UNIQUE_NAME__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentBuffer the data for the successful email message.
Use an existing validation rulefalse
Validation Rule Type

Schema for table_details_email :
ColumnKeyTypeLengthPrecisionNullableComment
Job_PIDfalseStringtrue
Run_Datefalsejava.util.Datetrue
TargetTableRowCount_BeforefalseIntegertrue
TargetTableRowCount_AfterfalseIntegertrue
SourceTableNamefalseStringtrue
TargetTableNamefalseStringtrue
SourceTableRowCountfalseIntegertrue

Original Function Parameters:
Component   tOracleInput

      UNIQUE NAMEtDBInput_2INPUT(S)tDBInput_6
LABELPS_UM_GLQ_ACCTAOUTPUT(S)tMap_3

Component Parameters:
PropertiesValues
DatabasetOracleInput
Unique NametDBInput_2
Component NametOracleInput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/Oracle
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tOracleInput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (ORACLE_SERVICE_NAME):FN_Connection
Use an existing connectionfalse
Component List
Connection TypeORACLE_SERVICE_NAME
DB VersionORACLE_11
URLcontext.FNContext_Server
Hostcontext.FNContext_Server
Database DriverORACLE_SERVICE_NAME
Portcontext.FNContext_Port
Databasecontext.FNContext_ServiceName
Local Service Namecontext.FNContext_ServiceName
Oracle schemacontext.FNContext_Schema
Usernamecontext.FNContext_Login
Passwordcontext.FNContext_Password
URL"jdbc:oracle:oci:/@talend"
REPOSITORY_ALLOW_AUTO_SWITCHtrue
Schemarepository: DB (ORACLE_SERVICE_NAME):FN_Connection - PS_UM_GLQ_ACCTA
Table Name"PS_UM_GLQ_ACCTA"
Query TypeBuilt-In
Guess Schema""
Query" SELECT FISCAL_YEAR, ACCOUNT, DESCR, DESCRSHORT, EFF_STATUS, UM_ACCT_CAT, UM_ACCT_CAT_D, UM_ACCT_DTL, UM_ACCT_DTL_D, UM_ACCT_GRP, UM_ACCT_GRP_D, UM_ACCT_GRP_SHRT, UM_ACCT_GRP_SHRT_D, UM_ACCT_SUBCAT, UM_ACCT_SUBCAT_D, UM_ACCT_SUM, UM_ACCT_SUM_D, UM_ACCT_SUM_SHRT, UM_ACCT_SUM_SHRT_D, UM_ACCT_TYPE, UM_ACCT_TYPE_D, UM_RPT_CAT, UM_RPT_CAT_D, UM_RPT_GRP, UM_RPT_GRP_D, UM_RPT_TYPE, UM_RPT_TYPE_D, UM_ACCT_CASH_FLW, UM_ACCT_CASH_FLW_D FROM "+context.FNContext_Schema+".PS_UM_GLQ_ACCTA WHERE FISCAL_YEAR between " + context.FY_Start + " and " + context.FY_End + " "
Specify a data source aliasfalse
Data source alias""
Mappingoracle_id
Additional JDBC Parameterscontext.FNContext_AdditionalParams
Convert XMLType To Java Type.(just when use extract() return a NODE)false
CONVERT_XMLTYPE[]
Encoding"ISO-8859-15"
Use cursortrue
Cursor size10000
Trim all the String/Char columnstrue
Trim column[{SCHEMA_COLUMN=FISCAL_YEAR, TRIM=false}, {SCHEMA_COLUMN=ACCOUNT, TRIM=false}, {SCHEMA_COLUMN=DESCR, TRIM=false}, {SCHEMA_COLUMN=DESCRSHORT, TRIM=false}, {SCHEMA_COLUMN=EFF_STATUS, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_CAT, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_CAT_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_DTL, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_DTL_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_GRP, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_GRP_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_GRP_SHRT, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_GRP_SHRT_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUBCAT, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUBCAT_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUM, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUM_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUM_SHRT, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_SUM_SHRT_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_TYPE, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_TYPE_D, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_CAT, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_CAT_D, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_GRP, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_GRP_D, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_TYPE, TRIM=false}, {SCHEMA_COLUMN=UM_RPT_TYPE_D, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_CASH_FLW, TRIM=false}, {SCHEMA_COLUMN=UM_ACCT_CASH_FLW_D, TRIM=false}]
No null valuesfalse
Label formatPS_UM_GLQ_ACCTA
Hint format<b>_PS_UM_GLQ_ACCTA_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentExtract from PS_UM_GLQ_ACCTA for loading to staging table.
Use an existing validation rulefalse
Validation Rule Type

Schema for PS_UM_GLQ_ACCTA :
ColumnKeyTypeLengthPrecisionNullableComment
FISCAL_YEARfalseint4false
ACCOUNTfalseString10false
DESCRfalseString30false
DESCRSHORTfalseString10false
EFF_STATUSfalseString1false
UM_ACCT_CATfalseString20false
UM_ACCT_CAT_DfalseString60false
UM_ACCT_DTLfalseString20false
UM_ACCT_DTL_DfalseString60false
UM_ACCT_GRPfalseString20false
UM_ACCT_GRP_DfalseString60false
UM_ACCT_GRP_SHRTfalseString20false
UM_ACCT_GRP_SHRT_DfalseString60false
UM_ACCT_SUBCATfalseString20false
UM_ACCT_SUBCAT_DfalseString60false
UM_ACCT_SUMfalseString20false
UM_ACCT_SUM_DfalseString60false
UM_ACCT_SUM_SHRTfalseString20false
UM_ACCT_SUM_SHRT_DfalseString60false
UM_ACCT_TYPEfalseString20false
UM_ACCT_TYPE_DfalseString60false
UM_RPT_CATfalseString20false
UM_RPT_CAT_DfalseString60false
UM_RPT_GRPfalseString20false
UM_RPT_GRP_DfalseString60false
UM_RPT_TYPEfalseString20false
UM_RPT_TYPE_DfalseString60false
UM_ACCT_CASH_FLWfalseString20false
UM_ACCT_CASH_FLW_DfalseString60false

Original Function Parameters:
Component   tMSSqlInput

      UNIQUE NAMEtDBInput_6INPUT(S)tJava_3
LABELTGT_Table_Before_CountOUTPUT(S)tMap_7,  tDBInput_2

Component Parameters:
PropertiesValues
DatabasetMSSqlInput
Unique NametDBInput_6
Component NametMSSqlInput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlInput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Use an existing connectionfalse
Component List
Property Typerepository: DB (MSSQL):SS_Staging_Connection
Hostcontext.SSS_Context_Server
JDBC ProviderMSSQL_PROP
Database DriverMSSQL
Portcontext.SSS_Context_Port
Schemacontext.SSS_Context_Schema
Databasecontext.SSS_Context_Database
Usernamecontext.SSS_Context_Login
Passwordcontext.SSS_Context_Password
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Table NameTGT_Table_Before_Count
Query TypeBuilt-In
Guess Schema""
Query" SELECT COUNT(*) AS TGTCountBefore FROM " + context.TGT_TableName_1
Specify a data source aliasfalse
Data source alias""
Mappingid_MSSQL
Additional JDBC Parameterscontext.SSS_Context_AdditionalParams
Encoding"ISO-8859-15"
Trim all the String/Char columnstrue
Trim column[{SCHEMA_COLUMN=TGTCountBefore, TRIM=false}]
Label formatTGT_Table_Before_Count
Hint format<b>_TGT_Table_Before_Count_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentReads the table to be processed capturing a before count for the target. This will then be compared to the after count in the email message in order to verify record change counts.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDBInput_6 :
ColumnKeyTypeLengthPrecisionNullableComment
TGTCountBeforefalseIntegertrue

Original Function Parameters:
Component   tMSSqlOutput

      UNIQUE NAMEtDBOutput_2INPUT(S)tMap_2
LABELDI_Flow_RowCounts_SRCOUTPUT(S)none

Component Parameters:
PropertiesValues
DatabasetMSSqlOutput
Unique NametDBOutput_2
Component NametMSSqlOutput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):DI_CNTL
Use an existing connectionfalse
Component List
JDBC ProviderMSSQL_PROP
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Database DriverMSSQL
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
Table"DI_Flow_RowCounts_SRC"
Action on tableNONE
Turn on Identity insertfalse
Action on dataINSERT
Specify identity fieldfalse
Identity fieldSRC_Database_1
Start value1
Step1
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Reject SchemaBuilt-In
Specify a data source aliasfalse
Data source alias""
Die on errortrue
Mappingid_MSSQL
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Encoding"ISO-8859-15"
Commit every100000
Additional columns[]
Use field optionsfalse
Field options[{SCHEMA_COLUMN=SRC_Database_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Database_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Schema_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Server_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_SOR_SK_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Table_No_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableName_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_TableRowCount_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SRC_Query_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Job_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Create_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Modify_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}]
Ignore date out of rangefalse
Enable debug modefalse
Support null in "SQL WHERE" statementfalse
Use Batch Sizetrue
Batch Size10000
Label formatDI_Flow_RowCounts_SRC
Hint format<b>_DI_Flow_RowCounts_SRC_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentUpdate flow counts to SRC db
Use an existing validation rulefalse
Validation Rule Type

Schema for DI_Flow_RowCounts_SRC :
ColumnKeyTypeLengthPrecisionNullableComment
SRC_Database_1falseString80true
SRC_Database_2falseString80true
SRC_Database_3falseString80true
SRC_Database_4falseString80true
SRC_Database_5falseString80true
SRC_Database_6falseString80true
SRC_Database_7falseString80true
SRC_Database_8falseString80true
SRC_Database_9falseString80true
SRC_Database_10falseString80true
SRC_Schema_1falseString80true
SRC_Schema_2falseString80true
SRC_Schema_3falseString80true
SRC_Schema_4falseString80true
SRC_Schema_5falseString80true
SRC_Schema_6falseString80true
SRC_Schema_7falseString80true
SRC_Schema_8falseString80true
SRC_Schema_9falseString80true
SRC_Schema_10falseString80true
SRC_Server_1falseString80true
SRC_Server_2falseString80true
SRC_Server_3falseString80true
SRC_Server_4falseString80true
SRC_Server_5falseString80true
SRC_Server_6falseString80true
SRC_Server_7falseString80true
SRC_Server_8falseString80true
SRC_Server_9falseString80true
SRC_Server_10falseString80true
SRC_SOR_SK_1falseInteger10true
SRC_SOR_SK_2falseInteger10true
SRC_SOR_SK_3falseInteger10true
SRC_SOR_SK_4falseInteger10true
SRC_SOR_SK_5falseInteger10true
SRC_SOR_SK_6falseInteger10true
SRC_SOR_SK_7falseInteger10true
SRC_SOR_SK_8falseInteger10true
SRC_SOR_SK_9falseInteger10true
SRC_SOR_SK_10falseInteger10true
SRC_Table_DI_Purpose_1falseString80true
SRC_Table_DI_Purpose_2falseString80true
SRC_Table_DI_Purpose_3falseString80true
SRC_Table_DI_Purpose_4falseString80true
SRC_Table_DI_Purpose_5falseString80true
SRC_Table_DI_Purpose_6falseString80true
SRC_Table_DI_Purpose_7falseString80true
SRC_Table_DI_Purpose_8falseString80true
SRC_Table_DI_Purpose_9falseString80true
SRC_Table_DI_Purpose_10falseString80true
SRC_Table_No_1falseInteger10true
SRC_Table_No_2falseInteger10true
SRC_Table_No_3falseInteger10true
SRC_Table_No_4falseInteger10true
SRC_Table_No_5falseInteger10true
SRC_Table_No_6falseInteger10true
SRC_Table_No_7falseInteger10true
SRC_Table_No_8falseInteger10true
SRC_Table_No_9falseInteger10true
SRC_Table_No_10falseInteger10true
SRC_TableName_1falseString80true
SRC_TableName_2falseString80true
SRC_TableName_3falseString80true
SRC_TableName_4falseString80true
SRC_TableName_5falseString80true
SRC_TableName_6falseString80true
SRC_TableName_7falseString80true
SRC_TableName_8falseString80true
SRC_TableName_9falseString80true
SRC_TableName_10falseString80true
SRC_TableRowCount_1falseInteger10true
SRC_TableRowCount_2falseInteger10true
SRC_TableRowCount_3falseInteger10true
SRC_TableRowCount_4falseInteger10true
SRC_TableRowCount_5falseInteger10true
SRC_TableRowCount_6falseInteger10true
SRC_TableRowCount_7falseInteger10true
SRC_TableRowCount_8falseInteger10true
SRC_TableRowCount_9falseInteger10true
SRC_TableRowCount_10falseInteger10true
SRC_Query_1falseString255true
SRC_Query_2falseString255true
SRC_Query_3falseString255true
SRC_Query_4falseString255true
SRC_Query_5falseString255true
SRC_Query_6falseString255true
SRC_Query_7falseString255true
SRC_Query_8falseString255true
SRC_Query_9falseString255true
SRC_Query_10falseString255true
DI_Job_PIDfalseString20false
DI_Create_Datefalsejava.util.Date233false
DI_Modify_Datefalsejava.util.Date233false

Original Function Parameters:
Component   tMSSqlOutput

      UNIQUE NAMEtDBOutput_3INPUT(S)tFlowMeter_9
LABELFN_UM_GLQ_ACCTAOUTPUT(S)tFixedFlowInput_1,  tDie_1

Component Parameters:
PropertiesValues
DatabasetMSSqlOutput
Unique NametDBOutput_3
Component NametMSSqlOutput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):SS_Staging_Connection
Use an existing connectionfalse
Component List
JDBC ProviderMSSQL_PROP
Hostcontext.SSS_Context_Server
Portcontext.SSS_Context_Port
Schemacontext.SSS_Context_Schema
Databasecontext.SSS_Context_Database
Database DriverMSSQL
Usernamecontext.SSS_Context_Login
Passwordcontext.SSS_Context_Password
Table"FN_UM_GLQ_ACCTA"
Action on tableTRUNCATE
Turn on Identity insertfalse
Action on dataINSERT
Specify identity fieldfalse
Identity fieldFISCAL_YEAR
Start value1
Step1
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Reject SchemaBuilt-In
Specify a data source aliasfalse
Data source alias""
Die on errortrue
Mappingid_MSSQL
Additional JDBC Parameterscontext.SSS_Context_AdditionalParams
Encoding"ISO-8859-15"
Commit every100000
Additional columns[]
Use field optionsfalse
Field options[{SCHEMA_COLUMN=FISCAL_YEAR, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=ACCOUNT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DESCR, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DESCRSHORT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=EFF_STATUS, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_CAT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_CAT_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_DTL, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_DTL_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_GRP, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_GRP_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_GRP_SHRT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_GRP_SHRT_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUBCAT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUBCAT_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUM, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUM_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUM_SHRT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_SUM_SHRT_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_TYPE, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_TYPE_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_CAT, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_CAT_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_GRP, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_GRP_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_TYPE, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_RPT_TYPE_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_CASH_FLW, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=UM_ACCT_CASH_FLW_D, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Job_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Create_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Modified_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}]
Ignore date out of rangefalse
Enable debug modefalse
Support null in "SQL WHERE" statementfalse
Use Batch Sizetrue
Batch Size100000
Label formatFN_UM_GLQ_ACCTA
Hint format<b>_FN_UM_GLQ_ACCTA_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentWrite FN_GLQ_ACCTA staging table.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDBOutput_3 :
ColumnKeyTypeLengthPrecisionNullableComment
FISCAL_YEARfalsefloat38false
ACCOUNTfalseString10false
DESCRfalseString30false
DESCRSHORTfalseString10false
EFF_STATUSfalseString1false
UM_ACCT_CATfalseString20false
UM_ACCT_CAT_DfalseString60false
UM_ACCT_DTLfalseString20false
UM_ACCT_DTL_DfalseString60false
UM_ACCT_GRPfalseString20false
UM_ACCT_GRP_DfalseString60false
UM_ACCT_GRP_SHRTfalseString20false
UM_ACCT_GRP_SHRT_DfalseString60false
UM_ACCT_SUBCATfalseString20false
UM_ACCT_SUBCAT_DfalseString60false
UM_ACCT_SUMfalseString20false
UM_ACCT_SUM_DfalseString60false
UM_ACCT_SUM_SHRTfalseString20false
UM_ACCT_SUM_SHRT_DfalseString60false
UM_ACCT_TYPEfalseString20false
UM_ACCT_TYPE_DfalseString60false
UM_RPT_CATfalseString20false
UM_RPT_CAT_DfalseString60false
UM_RPT_GRPfalseString20false
UM_RPT_GRP_DfalseString60false
UM_RPT_TYPEfalseString20false
UM_RPT_TYPE_DfalseString60false
UM_ACCT_CASH_FLWfalseString20false
UM_ACCT_CASH_FLW_DfalseString60false
DI_Job_PIDtrueString20false
DI_Create_Datetruejava.util.Datefalse
DI_Modified_Datetruejava.util.Datefalse

Original Function Parameters:
Component   tMSSqlOutput

      UNIQUE NAMEtDBOutput_4INPUT(S)tMap_2
LABELDI_Flow_RowCounts_TGTOUTPUT(S)none

Component Parameters:
PropertiesValues
DatabasetMSSqlOutput
Unique NametDBOutput_4
Component NametMSSqlOutput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):DI_CNTL
Use an existing connectionfalse
Component List
JDBC ProviderMSSQL_PROP
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Database DriverMSSQL
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
Table"DI_Flow_RowCounts_TGT"
Action on tableNONE
Turn on Identity insertfalse
Action on dataINSERT
Specify identity fieldfalse
Identity fieldTGT_Database_1
Start value1
Step1
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Reject SchemaBuilt-In
Specify a data source aliasfalse
Data source alias""
Die on errortrue
Mappingid_MSSQL
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Encoding"ISO-8859-15"
Commit every100000
Additional columns[]
Use field optionsfalse
Field options[{SCHEMA_COLUMN=TGT_Database_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Database_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Schema_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Server_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_SOR_SK_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Table_No_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableName_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_After_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsTotal_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsInserted_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsUpdated_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsDeleted_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_1, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_2, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_3, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_4, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_5, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_6, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_7, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_8, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_9, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_RowsRejected_10, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Job_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Create_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_Modify_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}]
Ignore date out of rangefalse
Enable debug modefalse
Support null in "SQL WHERE" statementfalse
Use Batch Sizetrue
Batch Size10000
Label formatDI_Flow_RowCounts_TGT
Hint format<b>_DI_Flow_RowCounts_TGT_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentUpdate flow counts to TGT db
Use an existing validation rulefalse
Validation Rule Type

Schema for DI_Flow_RowCounts_TGT :
ColumnKeyTypeLengthPrecisionNullableComment
TGT_Database_1falseString80true
TGT_Database_2falseString80true
TGT_Database_3falseString80true
TGT_Database_4falseString80true
TGT_Database_5falseString80true
TGT_Database_6falseString80true
TGT_Database_7falseString80true
TGT_Database_8falseString80true
TGT_Database_9falseString80true
TGT_Database_10falseString80true
TGT_Schema_1falseString80true
TGT_Schema_2falseString80true
TGT_Schema_3falseString80true
TGT_Schema_4falseString80true
TGT_Schema_5falseString80true
TGT_Schema_6falseString80true
TGT_Schema_7falseString80true
TGT_Schema_8falseString80true
TGT_Schema_9falseString80true
TGT_Schema_10falseString80true
TGT_Server_1falseString80true
TGT_Server_2falseString80true
TGT_Server_3falseString80true
TGT_Server_4falseString80true
TGT_Server_5falseString80true
TGT_Server_6falseString80true
TGT_Server_7falseString80true
TGT_Server_8falseString80true
TGT_Server_9falseString80true
TGT_Server_10falseString80true
TGT_SOR_SK_1falseInteger10true
TGT_SOR_SK_2falseInteger10true
TGT_SOR_SK_3falseInteger10true
TGT_SOR_SK_4falseInteger10true
TGT_SOR_SK_5falseInteger10true
TGT_SOR_SK_6falseInteger10true
TGT_SOR_SK_7falseInteger10true
TGT_SOR_SK_8falseInteger10true
TGT_SOR_SK_9falseInteger10true
TGT_SOR_SK_10falseInteger10true
TGT_Table_DI_Purpose_1falseString80true
TGT_Table_DI_Purpose_2falseString80true
TGT_Table_DI_Purpose_3falseString80true
TGT_Table_DI_Purpose_4falseString80true
TGT_Table_DI_Purpose_5falseString80true
TGT_Table_DI_Purpose_6falseString80true
TGT_Table_DI_Purpose_7falseString80true
TGT_Table_DI_Purpose_8falseString80true
TGT_Table_DI_Purpose_9falseString80true
TGT_Table_DI_Purpose_10falseString80true
TGT_Table_No_1falseInteger10true
TGT_Table_No_2falseInteger10true
TGT_Table_No_3falseInteger10true
TGT_Table_No_4falseInteger10true
TGT_Table_No_5falseInteger10true
TGT_Table_No_6falseInteger10true
TGT_Table_No_7falseInteger10true
TGT_Table_No_8falseInteger10true
TGT_Table_No_9falseInteger10true
TGT_Table_No_10falseInteger10true
TGT_TableName_1falseString80true
TGT_TableName_2falseString80true
TGT_TableName_3falseString80true
TGT_TableName_4falseString80true
TGT_TableName_5falseString80true
TGT_TableName_6falseString80true
TGT_TableName_7falseString80true
TGT_TableName_8falseString80true
TGT_TableName_9falseString80true
TGT_TableName_10falseString80true
TGT_TableRowCount_After_1falseInteger10true
TGT_TableRowCount_After_2falseInteger10true
TGT_TableRowCount_After_3falseInteger10true
TGT_TableRowCount_After_4falseInteger10true
TGT_TableRowCount_After_5falseInteger10true
TGT_TableRowCount_After_6falseInteger10true
TGT_TableRowCount_After_7falseInteger10true
TGT_TableRowCount_After_8falseInteger10true
TGT_TableRowCount_After_9falseInteger10true
TGT_TableRowCount_After_10falseInteger10true
TGT_TableRowCount_Before_1falseInteger10true
TGT_TableRowCount_Before_2falseInteger10true
TGT_TableRowCount_Before_3falseInteger10true
TGT_TableRowCount_Before_4falseInteger10true
TGT_TableRowCount_Before_5falseInteger10true
TGT_TableRowCount_Before_6falseInteger10true
TGT_TableRowCount_Before_7falseInteger10true
TGT_TableRowCount_Before_8falseInteger10true
TGT_TableRowCount_Before_9falseInteger10true
TGT_TableRowCount_Before_10falseInteger10true
TGT_RowsTotal_1falseInteger10true
TGT_RowsTotal_2falseInteger10true
TGT_RowsTotal_3falseInteger10true
TGT_RowsTotal_4falseInteger10true
TGT_RowsTotal_5falseInteger10true
TGT_RowsTotal_6falseInteger10true
TGT_RowsTotal_7falseInteger10true
TGT_RowsTotal_8falseInteger10true
TGT_RowsTotal_9falseInteger10true
TGT_RowsTotal_10falseInteger10true
TGT_RowsInserted_1falseInteger10true
TGT_RowsInserted_2falseInteger10true
TGT_RowsInserted_3falseInteger10true
TGT_RowsInserted_4falseInteger10true
TGT_RowsInserted_5falseInteger10true
TGT_RowsInserted_6falseInteger10true
TGT_RowsInserted_7falseInteger10true
TGT_RowsInserted_8falseInteger10true
TGT_RowsInserted_9falseInteger10true
TGT_RowsInserted_10falseInteger10true
TGT_RowsUpdated_1falseInteger10true
TGT_RowsUpdated_2falseInteger10true
TGT_RowsUpdated_3falseInteger10true
TGT_RowsUpdated_4falseInteger10true
TGT_RowsUpdated_5falseInteger10true
TGT_RowsUpdated_6falseInteger10true
TGT_RowsUpdated_7falseInteger10true
TGT_RowsUpdated_8falseInteger10true
TGT_RowsUpdated_9falseInteger10true
TGT_RowsUpdated_10falseInteger10true
TGT_RowsDeleted_1falseInteger10true
TGT_RowsDeleted_2falseInteger10true
TGT_RowsDeleted_3falseInteger10true
TGT_RowsDeleted_4falseInteger10true
TGT_RowsDeleted_5falseInteger10true
TGT_RowsDeleted_6falseInteger10true
TGT_RowsDeleted_7falseInteger10true
TGT_RowsDeleted_8falseInteger10true
TGT_RowsDeleted_9falseInteger10true
TGT_RowsDeleted_10falseInteger10true
TGT_RowsRejected_1falseInteger10true
TGT_RowsRejected_2falseInteger10true
TGT_RowsRejected_3falseInteger10true
TGT_RowsRejected_4falseInteger10true
TGT_RowsRejected_5falseInteger10true
TGT_RowsRejected_6falseInteger10true
TGT_RowsRejected_7falseInteger10true
TGT_RowsRejected_8falseInteger10true
TGT_RowsRejected_9falseInteger10true
TGT_RowsRejected_10falseInteger10true
DI_Job_PIDfalseString20false
DI_Create_Datefalsejava.util.Date233false
DI_Modify_Datefalsejava.util.Date233false

Original Function Parameters:
Component   tDie

      UNIQUE NAMEtDie_1INPUT(S)tDBOutput_3
LABEL__UNIQUE_NAME__OUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametDie_1
Component NametDie
Version0.102 (ALPHA)
FamilyLogs_Errors
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tDie
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Die message"Failure in FNS02 Write to FN_GLQ_REPRTING"
Error code0301
Priority5
Exit the JVM immediatelyfalse
SchemaBuilt-In
Label format__UNIQUE_NAME__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentTerminates the job with the specified error code.
Use an existing validation rulefalse
Validation Rule Type

Schema for tDie_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tFixedFlowInput

      UNIQUE NAMEtFixedFlowInput_1INPUT(S)tDBOutput_3
LABELFFI_Ten_to_TenOUTPUT(S)tMap_2

Component Parameters:
PropertiesValues
Unique NametFixedFlowInput_1
Component NametFixedFlowInput
Version0.102 (ALPHA)
FamilyMisc
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tFixedFlowInput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Number of rows1
Use Single Tabletrue
Values[{SCHEMA_COLUMN=SRC_Database_1, VALUE=context.FNContext_ServiceName}, {SCHEMA_COLUMN=SRC_Schema_1, VALUE=context.FNContext_Schema}, {SCHEMA_COLUMN=SRC_Server_1, VALUE=context.FNContext_Server}, {SCHEMA_COLUMN=SRC_SOR_SK_1, VALUE=context.SRC_SOR_SK_1}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_1, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_1, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_1, VALUE=context.SRC_TableName_1}, {SCHEMA_COLUMN=SRC_TableRowCount_1, VALUE=((Integer)globalMap.get("tDBInput_2_NB_LINE"))}, {SCHEMA_COLUMN=SRC_Query_1, VALUE=StringHandling.RIGHT( ((String)globalMap.get("tDBInput_2_QUERY")) , 255)}, {SCHEMA_COLUMN=SRC_Database_2, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_2, VALUE=}, {SCHEMA_COLUMN=SRC_Server_2, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_2, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_2, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_2, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_2, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_2, VALUE=}, {SCHEMA_COLUMN=SRC_Query_2, VALUE=}, {SCHEMA_COLUMN=SRC_Database_3, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_3, VALUE=}, {SCHEMA_COLUMN=SRC_Server_3, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_3, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_3, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_3, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_3, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_3, VALUE=}, {SCHEMA_COLUMN=SRC_Query_3, VALUE=}, {SCHEMA_COLUMN=SRC_Database_4, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_4, VALUE=}, {SCHEMA_COLUMN=SRC_Server_4, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_4, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_4, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_4, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_4, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_4, VALUE=}, {SCHEMA_COLUMN=SRC_Query_4, VALUE=}, {SCHEMA_COLUMN=SRC_Database_5, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_5, VALUE=}, {SCHEMA_COLUMN=SRC_Server_5, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_5, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_5, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_5, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_5, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_5, VALUE=}, {SCHEMA_COLUMN=SRC_Query_5, VALUE=}, {SCHEMA_COLUMN=SRC_Database_6, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_6, VALUE=}, {SCHEMA_COLUMN=SRC_Server_6, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_6, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_6, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_6, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_6, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_6, VALUE=}, {SCHEMA_COLUMN=SRC_Query_6, VALUE=}, {SCHEMA_COLUMN=SRC_Database_7, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_7, VALUE=}, {SCHEMA_COLUMN=SRC_Server_7, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_7, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_7, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_7, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_7, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_7, VALUE=}, {SCHEMA_COLUMN=SRC_Query_7, VALUE=}, {SCHEMA_COLUMN=SRC_Database_8, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_8, VALUE=}, {SCHEMA_COLUMN=SRC_Server_8, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_8, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_8, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_8, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_8, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_8, VALUE=}, {SCHEMA_COLUMN=SRC_Query_8, VALUE=}, {SCHEMA_COLUMN=SRC_Database_9, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_9, VALUE=}, {SCHEMA_COLUMN=SRC_Server_9, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_9, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_9, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_9, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_9, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_9, VALUE=}, {SCHEMA_COLUMN=SRC_Query_9, VALUE=}, {SCHEMA_COLUMN=SRC_Database_10, VALUE=}, {SCHEMA_COLUMN=SRC_Schema_10, VALUE=}, {SCHEMA_COLUMN=SRC_Server_10, VALUE=}, {SCHEMA_COLUMN=SRC_SOR_SK_10, VALUE=}, {SCHEMA_COLUMN=SRC_Table_DI_Purpose_10, VALUE=}, {SCHEMA_COLUMN=SRC_Table_No_10, VALUE=}, {SCHEMA_COLUMN=SRC_TableName_10, VALUE=}, {SCHEMA_COLUMN=SRC_TableRowCount_10, VALUE=}, {SCHEMA_COLUMN=SRC_Query_10, VALUE=}, {SCHEMA_COLUMN=TGT_Database_1, VALUE=context.SSS_Context_Database}, {SCHEMA_COLUMN=TGT_Schema_1, VALUE=context.SSS_Context_Schema}, {SCHEMA_COLUMN=TGT_Server_1, VALUE=context.SSS_Context_Server}, {SCHEMA_COLUMN=TGT_SOR_SK_1, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_1, VALUE=context.TGT_Table_DI_Purpose_1}, {SCHEMA_COLUMN=TGT_Table_No_1, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_1, VALUE=context.TGT_TableName_1}, {SCHEMA_COLUMN=TGT_TableRowCount_After_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE"))}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_1, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE"))}, {SCHEMA_COLUMN=TGT_RowsInserted_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE_INSERTED"))}, {SCHEMA_COLUMN=TGT_RowsUpdated_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE_UPDATED"))}, {SCHEMA_COLUMN=TGT_RowsDeleted_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE_DELETED"))}, {SCHEMA_COLUMN=TGT_RowsRejected_1, VALUE=((Integer)globalMap.get("tDBOutput_3_NB_LINE_REJECTED"))}, {SCHEMA_COLUMN=TGT_Database_2, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_2, VALUE=}, {SCHEMA_COLUMN=TGT_Server_2, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_2, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_2, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_2, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_2, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_2, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_2, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_2, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_2, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_2, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_2, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_2, VALUE=}, {SCHEMA_COLUMN=TGT_Database_3, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_3, VALUE=}, {SCHEMA_COLUMN=TGT_Server_3, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_3, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_3, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_3, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_3, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_3, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_3, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_3, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_3, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_3, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_3, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_3, VALUE=}, {SCHEMA_COLUMN=TGT_Database_4, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_4, VALUE=}, {SCHEMA_COLUMN=TGT_Server_4, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_4, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_4, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_4, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_4, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_4, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_4, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_4, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_4, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_4, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_4, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_4, VALUE=}, {SCHEMA_COLUMN=TGT_Database_5, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_5, VALUE=}, {SCHEMA_COLUMN=TGT_Server_5, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_5, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_5, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_5, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_5, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_5, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_5, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_5, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_5, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_5, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_5, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_5, VALUE=}, {SCHEMA_COLUMN=TGT_Database_6, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_6, VALUE=}, {SCHEMA_COLUMN=TGT_Server_6, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_6, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_6, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_6, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_6, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_6, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_6, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_6, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_6, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_6, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_6, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_6, VALUE=}, {SCHEMA_COLUMN=TGT_Database_7, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_7, VALUE=}, {SCHEMA_COLUMN=TGT_Server_7, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_7, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_7, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_7, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_7, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_7, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_7, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_7, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_7, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_7, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_7, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_7, VALUE=}, {SCHEMA_COLUMN=TGT_Database_8, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_8, VALUE=}, {SCHEMA_COLUMN=TGT_Server_8, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_8, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_8, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_8, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_8, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_8, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_8, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_8, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_8, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_8, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_8, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_8, VALUE=}, {SCHEMA_COLUMN=TGT_Database_9, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_9, VALUE=}, {SCHEMA_COLUMN=TGT_Server_9, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_9, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_9, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_9, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_9, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_9, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_9, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_9, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_9, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_9, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_9, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_9, VALUE=}, {SCHEMA_COLUMN=TGT_Database_10, VALUE=}, {SCHEMA_COLUMN=TGT_Schema_10, VALUE=}, {SCHEMA_COLUMN=TGT_Server_10, VALUE=}, {SCHEMA_COLUMN=TGT_SOR_SK_10, VALUE=}, {SCHEMA_COLUMN=TGT_Table_DI_Purpose_10, VALUE=}, {SCHEMA_COLUMN=TGT_Table_No_10, VALUE=}, {SCHEMA_COLUMN=TGT_TableName_10, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_After_10, VALUE=}, {SCHEMA_COLUMN=TGT_TableRowCount_Before_10, VALUE=}, {SCHEMA_COLUMN=TGT_RowsTotal_10, VALUE=}, {SCHEMA_COLUMN=TGT_RowsInserted_10, VALUE=}, {SCHEMA_COLUMN=TGT_RowsUpdated_10, VALUE=}, {SCHEMA_COLUMN=TGT_RowsDeleted_10, VALUE=}, {SCHEMA_COLUMN=TGT_RowsRejected_10, VALUE=}, {SCHEMA_COLUMN=DI_Job_PID, VALUE=}, {SCHEMA_COLUMN=DI_Create_Date, VALUE=}, {SCHEMA_COLUMN=DI_Modify_Date, VALUE=}]
Use Inline Tablefalse
Inline Table[]
Use Inline Content(delimited file)false
Row Separator"\n"
Field Separator";"
Content
Label formatFFI_Ten_to_Ten
Hint format<b>_FFI_Ten_to_Ten_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentFixed flow input 10 Source to 10 Target. Data from the FlowMeter is catured and the appropriate context variable are updated.
Use an existing validation rulefalse
Validation Rule Type

Schema for tFixedFlowInput_1 :
ColumnKeyTypeLengthPrecisionNullableComment
SRC_Database_1falseString80true
SRC_Schema_1falseString80true
SRC_Server_1falseString80true
SRC_SOR_SK_1falseInteger10true
SRC_Table_DI_Purpose_1falseString80true
SRC_Table_No_1falseInteger10true
SRC_TableName_1falseString80true
SRC_TableRowCount_1falseInteger10true
SRC_Query_1falseString255true
SRC_Database_2falseString80true
SRC_Schema_2falseString80true
SRC_Server_2falseString80true
SRC_SOR_SK_2falseInteger10true
SRC_Table_DI_Purpose_2falseString80true
SRC_Table_No_2falseInteger10true
SRC_TableName_2falseString80true
SRC_TableRowCount_2falseInteger10true
SRC_Query_2falseString255true
SRC_Database_3falseString80true
SRC_Schema_3falseString80true
SRC_Server_3falseString80true
SRC_SOR_SK_3falseInteger10true
SRC_Table_DI_Purpose_3falseString80true
SRC_Table_No_3falseInteger10true
SRC_TableName_3falseString80true
SRC_TableRowCount_3falseInteger10true
SRC_Query_3falseString255true
SRC_Database_4falseString80true
SRC_Schema_4falseString80true
SRC_Server_4falseString80true
SRC_SOR_SK_4falseInteger10true
SRC_Table_DI_Purpose_4falseString80true
SRC_Table_No_4falseInteger10true
SRC_TableName_4falseString80true
SRC_TableRowCount_4falseInteger10true
SRC_Query_4falseString255true
SRC_Database_5falseString80true
SRC_Schema_5falseString80true
SRC_Server_5falseString80true
SRC_SOR_SK_5falseInteger10true
SRC_Table_DI_Purpose_5falseString80true
SRC_Table_No_5falseInteger10true
SRC_TableName_5falseString80true
SRC_TableRowCount_5falseInteger10true
SRC_Query_5falseString255true
SRC_Database_6falseString80true
SRC_Schema_6falseString80true
SRC_Server_6falseString80true
SRC_SOR_SK_6falseInteger10true
SRC_Table_DI_Purpose_6falseString80true
SRC_Table_No_6falseInteger10true
SRC_TableName_6falseString80true
SRC_TableRowCount_6falseInteger10true
SRC_Query_6falseString255true
SRC_Database_7falseString80true
SRC_Schema_7falseString80true
SRC_Server_7falseString80true
SRC_SOR_SK_7falseInteger10true
SRC_Table_DI_Purpose_7falseString80true
SRC_Table_No_7falseInteger10true
SRC_TableName_7falseString80true
SRC_TableRowCount_7falseInteger10true
SRC_Query_7falseString255true
SRC_Database_8falseString80true
SRC_Schema_8falseString80true
SRC_Server_8falseString80true
SRC_SOR_SK_8falseInteger10true
SRC_Table_DI_Purpose_8falseString80true
SRC_Table_No_8falseInteger10true
SRC_TableName_8falseString80true
SRC_TableRowCount_8falseInteger10true
SRC_Query_8falseString255true
SRC_Database_9falseString80true
SRC_Schema_9falseString80true
SRC_Server_9falseString80true
SRC_SOR_SK_9falseInteger10true
SRC_Table_DI_Purpose_9falseString80true
SRC_Table_No_9falseInteger10true
SRC_TableName_9falseString80true
SRC_TableRowCount_9falseInteger10true
SRC_Query_9falseString255true
SRC_Database_10falseString80true
SRC_Schema_10falseString80true
SRC_Server_10falseString80true
SRC_SOR_SK_10falseInteger10true
SRC_Table_DI_Purpose_10falseString80true
SRC_Table_No_10falseInteger10true
SRC_TableName_10falseString80true
SRC_TableRowCount_10falseInteger10true
SRC_Query_10falseString255true
TGT_Database_1falseString80true
TGT_Schema_1falseString80true
TGT_Server_1falseString80true
TGT_SOR_SK_1falseInteger10true
TGT_Table_DI_Purpose_1falseString80true
TGT_Table_No_1falseInteger10true
TGT_TableName_1falseString80true
TGT_TableRowCount_After_1falseInteger10true
TGT_TableRowCount_Before_1falseInteger10true
TGT_RowsTotal_1falseInteger10true
TGT_RowsInserted_1falseInteger10true
TGT_RowsUpdated_1falseInteger10true
TGT_RowsDeleted_1falseInteger10true
TGT_RowsRejected_1falseInteger10true
TGT_Database_2falseString80true
TGT_Schema_2falseString80true
TGT_Server_2falseString80true
TGT_SOR_SK_2falseInteger10true
TGT_Table_DI_Purpose_2falseString80true
TGT_Table_No_2falseInteger10true
TGT_TableName_2falseString80true
TGT_TableRowCount_After_2falseInteger10true
TGT_TableRowCount_Before_2falseInteger10true
TGT_RowsTotal_2falseInteger10true
TGT_RowsInserted_2falseInteger10true
TGT_RowsUpdated_2falseInteger10true
TGT_RowsDeleted_2falseInteger10true
TGT_RowsRejected_2falseInteger10true
TGT_Database_3falseString80true
TGT_Schema_3falseString80true
TGT_Server_3falseString80true
TGT_SOR_SK_3falseInteger10true
TGT_Table_DI_Purpose_3falseString80true
TGT_Table_No_3falseInteger10true
TGT_TableName_3falseString80true
TGT_TableRowCount_After_3falseInteger10true
TGT_TableRowCount_Before_3falseInteger10true
TGT_RowsTotal_3falseInteger10true
TGT_RowsInserted_3falseInteger10true
TGT_RowsUpdated_3falseInteger10true
TGT_RowsDeleted_3falseInteger10true
TGT_RowsRejected_3falseInteger10true
TGT_Database_4falseString80true
TGT_Schema_4falseString80true
TGT_Server_4falseString80true
TGT_SOR_SK_4falseInteger10true
TGT_Table_DI_Purpose_4falseString80true
TGT_Table_No_4falseInteger10true
TGT_TableName_4falseString80true
TGT_TableRowCount_After_4falseInteger10true
TGT_TableRowCount_Before_4falseInteger10true
TGT_RowsTotal_4falseInteger10true
TGT_RowsInserted_4falseInteger10true
TGT_RowsUpdated_4falseInteger10true
TGT_RowsDeleted_4falseInteger10true
TGT_RowsRejected_4falseInteger10true
TGT_Database_5falseString80true
TGT_Schema_5falseString80true
TGT_Server_5falseString80true
TGT_SOR_SK_5falseInteger10true
TGT_Table_DI_Purpose_5falseString80true
TGT_Table_No_5falseInteger10true
TGT_TableName_5falseString80true
TGT_TableRowCount_After_5falseInteger10true
TGT_TableRowCount_Before_5falseInteger10true
TGT_RowsTotal_5falseInteger10true
TGT_RowsInserted_5falseInteger10true
TGT_RowsUpdated_5falseInteger10true
TGT_RowsDeleted_5falseInteger10true
TGT_RowsRejected_5falseInteger10true
TGT_Database_6falseString80true
TGT_Schema_6falseString80true
TGT_Server_6falseString80true
TGT_SOR_SK_6falseInteger10true
TGT_Table_DI_Purpose_6falseString80true
TGT_Table_No_6falseInteger10true
TGT_TableName_6falseString80true
TGT_TableRowCount_After_6falseInteger10true
TGT_TableRowCount_Before_6falseInteger10true
TGT_RowsTotal_6falseInteger10true
TGT_RowsInserted_6falseInteger10true
TGT_RowsUpdated_6falseInteger10true
TGT_RowsDeleted_6falseInteger10true
TGT_RowsRejected_6falseInteger10true
TGT_Database_7falseString80true
TGT_Schema_7falseString80true
TGT_Server_7falseString80true
TGT_SOR_SK_7falseInteger10true
TGT_Table_DI_Purpose_7falseString80true
TGT_Table_No_7falseInteger10true
TGT_TableName_7falseString80true
TGT_TableRowCount_After_7falseInteger10true
TGT_TableRowCount_Before_7falseInteger10true
TGT_RowsTotal_7falseInteger10true
TGT_RowsInserted_7falseInteger10true
TGT_RowsUpdated_7falseInteger10true
TGT_RowsDeleted_7falseInteger10true
TGT_RowsRejected_7falseInteger10true
TGT_Database_8falseString80true
TGT_Schema_8falseString80true
TGT_Server_8falseString80true
TGT_SOR_SK_8falseInteger10true
TGT_Table_DI_Purpose_8falseString80true
TGT_Table_No_8falseInteger10true
TGT_TableName_8falseString80true
TGT_TableRowCount_After_8falseInteger10true
TGT_TableRowCount_Before_8falseInteger10true
TGT_RowsTotal_8falseInteger10true
TGT_RowsInserted_8falseInteger10true
TGT_RowsUpdated_8falseInteger10true
TGT_RowsDeleted_8falseInteger10true
TGT_RowsRejected_8falseInteger10true
TGT_Database_9falseString80true
TGT_Schema_9falseString80true
TGT_Server_9falseString80true
TGT_SOR_SK_9falseInteger10true
TGT_Table_DI_Purpose_9falseString80true
TGT_Table_No_9falseInteger10true
TGT_TableName_9falseString80true
TGT_TableRowCount_After_9falseInteger10true
TGT_TableRowCount_Before_9falseInteger10true
TGT_RowsTotal_9falseInteger10true
TGT_RowsInserted_9falseInteger10true
TGT_RowsUpdated_9falseInteger10true
TGT_RowsDeleted_9falseInteger10true
TGT_RowsRejected_9falseInteger10true
TGT_Database_10falseString80true
TGT_Schema_10falseString80true
TGT_Server_10falseString80true
TGT_SOR_SK_10falseInteger10true
TGT_Table_DI_Purpose_10falseString80true
TGT_Table_No_10falseInteger10true
TGT_TableName_10falseString80true
TGT_TableRowCount_After_10falseInteger10true
TGT_TableRowCount_Before_10falseInteger10true
TGT_RowsTotal_10falseInteger10true
TGT_RowsInserted_10falseInteger10true
TGT_RowsUpdated_10falseInteger10true
TGT_RowsDeleted_10falseInteger10true
TGT_RowsRejected_10falseInteger10true
DI_Job_PIDfalseString20true
DI_Create_Datefalsejava.util.Date23true
DI_Modify_Datefalsejava.util.Date23true

Original Function Parameters:
Component   tFlowMeter

      UNIQUE NAMEtFlowMeter_9INPUT(S)tMap_3
LABELFlowbee_03OUTPUT(S)tDBOutput_3

Component Parameters:
PropertiesValues
Unique NametFlowMeter_9
Component NametFlowMeter
Version0.101 (ALPHA)
FamilyLogs_Errors
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.FlowMeter
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Use input connection name as labeltrue
Label"MyLabel"
ModeAbsolute
Connections List
Thresholds[]
SchemaBuilt-In
Label formatFlowbee_03
Hint format<b>_Flowbee_03_</b><br>__COMMENT__
Connection formatrow
Show Informationtrue
CommentFlow Meter
Use an existing validation rulefalse
Validation Rule Type

Schema for tFlowMeter_9 :
ColumnKeyTypeLengthPrecisionNullableComment
FISCAL_YEARfalsefloat38false
ACCOUNTfalseString10false
DESCRfalseString30false
DESCRSHORTfalseString10false
EFF_STATUSfalseString1false
UM_ACCT_CATfalseString20false
UM_ACCT_CAT_DfalseString60false
UM_ACCT_DTLfalseString20false
UM_ACCT_DTL_DfalseString60false
UM_ACCT_GRPfalseString20false
UM_ACCT_GRP_DfalseString60false
UM_ACCT_GRP_SHRTfalseString20false
UM_ACCT_GRP_SHRT_DfalseString60false
UM_ACCT_SUBCATfalseString20false
UM_ACCT_SUBCAT_DfalseString60false
UM_ACCT_SUMfalseString20false
UM_ACCT_SUM_DfalseString60false
UM_ACCT_SUM_SHRTfalseString20false
UM_ACCT_SUM_SHRT_DfalseString60false
UM_ACCT_TYPEfalseString20false
UM_ACCT_TYPE_DfalseString60false
UM_RPT_CATfalseString20false
UM_RPT_CAT_DfalseString60false
UM_RPT_GRPfalseString20false
UM_RPT_GRP_DfalseString60false
UM_RPT_TYPEfalseString20false
UM_RPT_TYPE_DfalseString60false
UM_ACCT_CASH_FLWfalseString20false
UM_ACCT_CASH_FLW_DfalseString60false
DI_Job_PIDtrueString20false
DI_Create_Datetruejava.util.Datefalse
DI_Modified_Datetruejava.util.Datefalse

Original Function Parameters:
Component   tJavaRow

      UNIQUE NAMEtJavaRow_4INPUT(S)tMap_7
LABELSet_ContextOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJavaRow_4
Component NametJavaRow
Version0.101 (ALPHA)
FamilyCustom_Code
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJavaRow
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Code// code sample: // // multiply by 2 the row identifier // output_row.id = input_row.id * 2; // // lowercase the name // output_row.name = input_row.name.toLowerCase(); context.TGT_TableRowCount_Before_1 = put_count.TGTCountBefore;
Import//import java.util.List;
Label formatSet_Context
Hint format<b>_Set_Context_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentSet the TGT_TableRowCount_Before_1 context variable.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJavaRow_4 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_2INPUT(S)none
LABELClear_FN_Job_ContextsOUTPUT(S)tJava_3

Component Parameters:
PropertiesValues
Unique NametJava_2
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Starttrue
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Code// ***** CHANGE Job Specific Contexts Below ***** // // SOURCE Contexts Below // context.SRC_Database_1 = " "; context.SRC_Database_2 = " "; context.SRC_Database_3 = " "; context.SRC_Database_4 = " "; context.SRC_Database_5 = " "; context.SRC_Database_6 = " "; context.SRC_Database_7 = " "; context.SRC_Database_8 = " "; context.SRC_Database_9 = " "; context.SRC_Database_10 = " "; context.SRC_Schema_1 = " "; context.SRC_Schema_2 = " "; context.SRC_Schema_3 = " "; context.SRC_Schema_4 = " "; context.SRC_Schema_5 = " "; context.SRC_Schema_6 = " "; context.SRC_Schema_7 = " "; context.SRC_Schema_8 = " "; context.SRC_Schema_9 = " "; context.SRC_Schema_10 = " "; context.SRC_Server_1 = " "; context.SRC_Server_2 = " "; context.SRC_Server_3 = " "; context.SRC_Server_4 = " "; context.SRC_Server_5 = " "; context.SRC_Server_6 = " "; context.SRC_Server_7 = " "; context.SRC_Server_8 = " "; context.SRC_Server_9 = " "; context.SRC_Server_10 = " "; context.SRC_SOR_SK_1 = 1; context.SRC_SOR_SK_2 = 1; context.SRC_SOR_SK_3 = 1; context.SRC_SOR_SK_4 = 1; context.SRC_SOR_SK_5 = 1; context.SRC_SOR_SK_6 = 1; context.SRC_SOR_SK_7 = 1; context.SRC_SOR_SK_8 = 1; context.SRC_SOR_SK_9 = 1; context.SRC_SOR_SK_10 = 1; context.SRC_Table_DI_Purpose_1 = " "; context.SRC_Table_DI_Purpose_2 = " "; context.SRC_Table_DI_Purpose_3 = " "; context.SRC_Table_DI_Purpose_4 = " "; context.SRC_Table_DI_Purpose_5 = " "; context.SRC_Table_DI_Purpose_6 = " "; context.SRC_Table_DI_Purpose_7 = " "; context.SRC_Table_DI_Purpose_8 = " "; context.SRC_Table_DI_Purpose_9 = " "; context.SRC_Table_DI_Purpose_10 = " "; context.SRC_Table_No_1 = 0; context.SRC_Table_No_2 = 0; context.SRC_Table_No_3 = 0; context.SRC_Table_No_4 = 0; context.SRC_Table_No_5 = 0; context.SRC_Table_No_6 = 0; context.SRC_Table_No_7 = 0; context.SRC_Table_No_8 = 0; context.SRC_Table_No_9 = 0; context.SRC_Table_No_10 = 0; context.SRC_TableName_1 = " "; context.SRC_TableName_2 = " "; context.SRC_TableName_3 = " "; context.SRC_TableName_4 = " "; context.SRC_TableName_5 = " "; context.SRC_TableName_6 = " "; context.SRC_TableName_7 = " "; context.SRC_TableName_8 = " "; context.SRC_TableName_9 = " "; context.SRC_TableName_10 = " "; context.SRC_TableRowCount_1 = 0; context.SRC_TableRowCount_2 = 0; context.SRC_TableRowCount_3 = 0; context.SRC_TableRowCount_4 = 0; context.SRC_TableRowCount_5 = 0; context.SRC_TableRowCount_6 = 0; context.SRC_TableRowCount_7 = 0; context.SRC_TableRowCount_8 = 0; context.SRC_TableRowCount_9 = 0; context.SRC_TableRowCount_10 = 0; context.SRC_Query_1 = " "; context.SRC_Query_2 = " "; context.SRC_Query_3 = " "; context.SRC_Query_4 = " "; context.SRC_Query_5 = " "; context.SRC_Query_6 = " "; context.SRC_Query_7 = " "; context.SRC_Query_8 = " "; context.SRC_Query_9 = " "; context.SRC_Query_10 = " "; // SOURCE Contexts Above // // TARGET Contexts Below // context.TGT_Database_1 = " "; context.TGT_Database_2 = " "; context.TGT_Database_3 = " "; context.TGT_Database_4 = " "; context.TGT_Database_5 = " "; context.TGT_Database_6 = " "; context.TGT_Database_7 = " "; context.TGT_Database_8 = " "; context.TGT_Database_9 = " "; context.TGT_Database_10 = " "; context.TGT_Schema_1 = " "; context.TGT_Schema_2 = " "; context.TGT_Schema_3 = " "; context.TGT_Schema_4 = " "; context.TGT_Schema_5 = " "; context.TGT_Schema_6 = " "; context.TGT_Schema_7 = " "; context.TGT_Schema_8 = " "; context.TGT_Schema_9 = " "; context.TGT_Schema_10 = " "; context.TGT_Server_1 = " "; context.TGT_Server_2 = " "; context.TGT_Server_3 = " "; context.TGT_Server_4 = " "; context.TGT_Server_5 = " "; context.TGT_Server_6 = " "; context.TGT_Server_7 = " "; context.TGT_Server_8 = " "; context.TGT_Server_9 = " "; context.TGT_Server_10 = " "; context.TGT_SOR_SK_1 = 1; context.TGT_SOR_SK_2 = 1; context.TGT_SOR_SK_3 = 1; context.TGT_SOR_SK_4 = 1; context.TGT_SOR_SK_5 = 1; context.TGT_SOR_SK_6 = 1; context.TGT_SOR_SK_7 = 1; context.TGT_SOR_SK_8 = 1; context.TGT_SOR_SK_9 = 1; context.TGT_SOR_SK_10 = 1; context.TGT_Table_DI_Purpose_1 = " "; context.TGT_Table_DI_Purpose_2 = " "; context.TGT_Table_DI_Purpose_3 = " "; context.TGT_Table_DI_Purpose_4 = " "; context.TGT_Table_DI_Purpose_5 = " "; context.TGT_Table_DI_Purpose_6 = " "; context.TGT_Table_DI_Purpose_7 = " "; context.TGT_Table_DI_Purpose_8 = " "; context.TGT_Table_DI_Purpose_9 = " "; context.TGT_Table_DI_Purpose_10 = " "; context.TGT_Table_No_1 = 0; context.TGT_Table_No_2 = 0; context.TGT_Table_No_3 = 0; context.TGT_Table_No_4 = 0; context.TGT_Table_No_5 = 0; context.TGT_Table_No_6 = 0; context.TGT_Table_No_7 = 0; context.TGT_Table_No_8 = 0; context.TGT_Table_No_9 = 0; context.TGT_Table_No_10 = 0; context.TGT_TableName_1 = " "; context.TGT_TableName_2 = " "; context.TGT_TableName_3 = " "; context.TGT_TableName_4 = " "; context.TGT_TableName_5 = " "; context.TGT_TableName_6 = " "; context.TGT_TableName_7 = " "; context.TGT_TableName_8 = " "; context.TGT_TableName_9 = " "; context.TGT_TableName_10 = " "; context.TGT_TableRowCount_After_1 = 0; context.TGT_TableRowCount_After_2 = 0; context.TGT_TableRowCount_After_3 = 0; context.TGT_TableRowCount_After_4 = 0; context.TGT_TableRowCount_After_5 = 0; context.TGT_TableRowCount_After_6 = 0; context.TGT_TableRowCount_After_7 = 0; context.TGT_TableRowCount_After_8 = 0; context.TGT_TableRowCount_After_9 = 0; context.TGT_TableRowCount_After_10 = 0; context.TGT_TableRowCount_Before_1 = 0; context.TGT_TableRowCount_Before_2 = 0; context.TGT_TableRowCount_Before_3 = 0; context.TGT_TableRowCount_Before_4 = 0; context.TGT_TableRowCount_Before_5 = 0; context.TGT_TableRowCount_Before_6 = 0; context.TGT_TableRowCount_Before_7 = 0; context.TGT_TableRowCount_Before_8 = 0; context.TGT_TableRowCount_Before_9 = 0; context.TGT_TableRowCount_Before_10 = 0; context.TGT_RowsTotal_1 = 0; context.TGT_RowsTotal_2 = 0; context.TGT_RowsTotal_3 = 0; context.TGT_RowsTotal_4 = 0; context.TGT_RowsTotal_5 = 0; context.TGT_RowsTotal_6 = 0; context.TGT_RowsTotal_7 = 0; context.TGT_RowsTotal_8 = 0; context.TGT_RowsTotal_9 = 0; context.TGT_RowsTotal_10 = 0; context.TGT_RowsInserted_1 = 0; context.TGT_RowsInserted_2 = 0; context.TGT_RowsInserted_3 = 0; context.TGT_RowsInserted_4 = 0; context.TGT_RowsInserted_5 = 0; context.TGT_RowsInserted_6 = 0; context.TGT_RowsInserted_7 = 0; context.TGT_RowsInserted_8 = 0; context.TGT_RowsInserted_9 = 0; context.TGT_RowsInserted_10 = 0; context.TGT_RowsUpdated_1 = 0; context.TGT_RowsUpdated_2 = 0; context.TGT_RowsUpdated_3 = 0; context.TGT_RowsUpdated_4 = 0; context.TGT_RowsUpdated_5 = 0; context.TGT_RowsUpdated_6 = 0; context.TGT_RowsUpdated_7 = 0; context.TGT_RowsUpdated_8 = 0; context.TGT_RowsUpdated_9 = 0; context.TGT_RowsUpdated_10 = 0; context.TGT_RowsDeleted_1 = 0; context.TGT_RowsDeleted_2 = 0; context.TGT_RowsDeleted_3 = 0; context.TGT_RowsDeleted_4 = 0; context.TGT_RowsDeleted_5 = 0; context.TGT_RowsDeleted_6 = 0; context.TGT_RowsDeleted_7 = 0; context.TGT_RowsDeleted_8 = 0; context.TGT_RowsDeleted_9 = 0; context.TGT_RowsDeleted_10 = 0; context.TGT_RowsRejected_1 = 0; context.TGT_RowsRejected_2 = 0; context.TGT_RowsRejected_3 = 0; context.TGT_RowsRejected_4 = 0; context.TGT_RowsRejected_5 = 0; context.TGT_RowsRejected_6 = 0; context.TGT_RowsRejected_7 = 0; context.TGT_RowsRejected_8 = 0; context.TGT_RowsRejected_9 = 0; context.TGT_RowsRejected_10 = 0; // TARGET Contexts Above //
Import//import java.util.List;
SchemaBuilt-In
Label formatClear_FN_Job_Contexts
Hint format<b>_Clear_FN_Job_Contexts_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentClears the step specific job contexts.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_3INPUT(S)tJava_2
LABELSet_FN_Job_Contexts_For_Job_StepOUTPUT(S)tDBInput_6

Component Parameters:
PropertiesValues
Unique NametJava_3
Component NametJava
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJava
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Code// ***** CHANGE Job Specific Contexts Below ***** // // SOURCE Contexts Below // context.SRC_TableName_1 = "PS_UM_GLQ_ACCTA"; context.SRC_Server_1 = context.FNContext_Server; context.SRC_Database_1 = context.FNContext_ServiceName; context.SRC_Schema_1 = context.FNContext_Schema; // SOURCE Contexts Above // // TARGET Contexts Below // context.TGT_TableName_1 = "FN_UM_GLQ_ACCTA"; // TARGET Contexts Above // // ***** PRINT Job Specific Contexts Below ***** // System.out.println(" "); System.out.println("Variables from FN_Staging_03_UM-GLQ_ACCTA"); System.out.println("context.FY_Start = " + context.FY_Start ); System.out.println("context.FY_End = " + context.FY_End ); System.out.println(" "); System.out.println("context.SRC_TableName_1 = " + context.SRC_TableName_1 ); System.out.println("context.SRC_Server_1 = " + context.SRC_Server_1 ); System.out.println("context.SRC_Database_1 = " + context.SRC_Database_1 ); System.out.println("context.SRC_Schema_1 = " + context.SRC_Schema_1 ); System.out.println(" "); System.out.println("context.TGT_TableName_1 = " + context.TGT_TableName_1 ); System.out.println(" ");
Import//import java.util.List;
SchemaBuilt-In
Label formatSet_FN_Job_Contexts_For_Job_Step
Hint format<b>_Set_FN_Job_Contexts_For_Job_Step_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentSets step specific contexts
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_3 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tLogCatcher

      UNIQUE NAMEtLogCatcher_1INPUT(S)none
LABEL__UNIQUE_NAME__OUTPUT(S)tMap_1

Component Parameters:
PropertiesValues
Unique NametLogCatcher_1
Component NametLogCatcher
Version0.101 (ALPHA)
FamilyLogs_Errors
Starttrue
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tLogCatcher
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Catch Java Exceptiontrue
Catch tDietrue
Catch tWarntrue
Catch tJobFailuretrue
Label format__UNIQUE_NAME__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
Comment
Use an existing validation rulefalse
Validation Rule Type

Schema for tLogCatcher_1 :
ColumnKeyTypeLengthPrecisionNullableComment
momentfalsejava.util.Datetrue
pidfalseString20true
root_pidfalseString20true
father_pidfalseString20true
projectfalseString50true
jobfalseString255true
contextfalseString50true
priorityfalseInteger3true
typefalseString255true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tSendMail

      UNIQUE NAMEtSendMail_1INPUT(S)tSetGlobalVar_1
LABELsend_LogCatcher_notifyOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametSendMail_1
Component NametSendMail
Version0.101 (ALPHA)
FamilyInternet
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tSendMail
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Tocontext.tsendMailToFailure
Fromcontext.tsendMailFrom
Show sender's name?true
Sendernamecontext.tsendMailUsername
Cc
Bcc
Subject"*** ERROR *** Talend Job " + ((String)globalMap.get("vErrorJob")) + " (" +((String)globalMap.get("vErrorJobPID")) + ") *** Failed ***"
Message"Error Project: "+((String)globalMap.get("vErrorProject")) + "\n" + "\nJob: " + ((String)globalMap.get("vErrorJob")) + " ( " + ((String)globalMap.get("vErrorJobPID")) + " ) " + "\n" + "\nError Root Job PID: " + ((String)globalMap.get("vErrorRootPID")) + "\n" + "\nError message: "+((String)globalMap.get("vErrorMessage"))
Die if the attachment file doesn't exist.false
Attachments[]
Other headers[]
SMTP hostcontext.tsendMailSMTPHost
SMTP portcontext.tsendMailSMTPPort
SSL Supporttrue
STARTTLS Supportfalse
ImportanceNormal
Need authentication?false
Usernamecontext.tsendMailUsername
Password**************
Die on errortrue
MIME subtype from the 'text' MIME typeplain
charset used for encoding message"UTF-8"
Set localhostfalse
Localhost"localhost"
SchemaBuilt-In
Label formatsend_LogCatcher_notify
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
Comment
Use an existing validation rulefalse
Validation Rule Type

Schema for out_GlobalVar :
ColumnKeyTypeLengthPrecisionNullableComment
pidfalseString20true
root_pidfalseString20true
jobfalseString255true
projectfalseString50true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tSetGlobalVar

      UNIQUE NAMEtSetGlobalVar_1INPUT(S)tMap_1
LABELset_GlobalVar_LogOUTPUT(S)tSendMail_1

Component Parameters:
PropertiesValues
Unique NametSetGlobalVar_1
Component NametSetGlobalVar
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tSetGlobalVar
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Variables[{KEY="vErrorJobPID", VALUE=out_glovar.pid}, {KEY="vErrorRootPID", VALUE=out_glovar.root_pid}, {KEY="vErrorJob", VALUE=out_glovar.job}, {KEY="vErrorProject", VALUE=out_glovar.project}, {KEY="vErrorOrigin", VALUE=out_glovar.origin}, {KEY="vErrorMessage", VALUE=out_glovar.message }, {KEY="vErrorCode", VALUE=out_glovar.code}]
SchemaBuilt-In
Label formatset_GlobalVar_Log
Hint format<b>_set_GlobalVar_Log_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
Comment
Use an existing validation rulefalse
Validation Rule Type

Schema for out_GlobalVar :
ColumnKeyTypeLengthPrecisionNullableComment
pidfalseString20true
root_pidfalseString20true
jobfalseString255true
projectfalseString50true
originfalseString255true
messagefalseString255true
codefalseInteger3true

Original Function Parameters:
Component   tMap

      UNIQUE NAMEtMap_1INPUT(S)tLogCatcher_1
LABEL__UNIQUE_NAME__OUTPUT(S)tSetGlobalVar_1



Component Parameters:
PropertiesValues
tStatCatcher Statistics
false
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
false
Show Information
false
Comment
Use an existing validation rule
false

Mapper table for tMap_1
				(
				input
				):
			
Mapper table Properties(
								logc
								):
							
PropertiesValues
Namelogc
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								logc
								):
							
NameTypeExpressionisNullable
momentjava.util.Datetrue
pidStringtrue
root_pidStringtrue
father_pidStringtrue
projectStringtrue
jobStringtrue
contextStringtrue
priorityIntegertrue
typeStringtrue
originStringtrue
messageStringtrue
codeIntegertrue

Constraint Table Entries(
								logc
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_1
				(
				output
				):
			
Mapper table Properties(
								out_log
								):
							
PropertiesValues
Nameout_log
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								out_log
								):
							
NameTypeExpressionisNullable
momentjava.util.Datelogc.momenttrue
pidStringlogc.pidtrue
root_pidStringlogc.root_pidtrue
father_pidStringlogc.father_pidtrue
projectStringlogc.projecttrue
jobStringlogc.jobtrue
contextStringlogc.contexttrue
priorityIntegerlogc.prioritytrue
typeStringlogc.typetrue
originStringlogc.origintrue
messageStringlogc.messagetrue
codeIntegerlogc.codetrue

Constraint Table Entries(
								out_log
								):
							
NameTypeExpressionisNullable

Mapper table Properties(
								out_glovar
								):
							
PropertiesValues
Nameout_glovar
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								out_glovar
								):
							
NameTypeExpressionisNullable
pidStringlogc.pidtrue
root_pidStringlogc.root_pidtrue
jobStringlogc.jobtrue
projectStringlogc.projecttrue
originStringlogc.origintrue
messageStringlogc.messagetrue
codeIntegerlogc.codetrue

Constraint Table Entries(
								out_glovar
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_1
				(
				var
				):
			
Mapper table Properties(
								Var
								):
							
PropertiesValues
NameVar
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Component  									tMap

								     							UNIQUE NAMEtMap_2INPUT(S)tFixedFlowInput_1
LABEL__UNIQUE_NAME__OUTPUT(S)tDBOutput_2,  tDBOutput_4,  tBufferOutput_1



Component Parameters:
PropertiesValues
tStatCatcher Statistics
false
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
true
Show Information
false
Comment
Maps the data to be loaded into the DI_CNTL TGT and SRC tables along with the data to be buffered for the successful email process.
Use an existing validation rule
false

Mapper table for tMap_2
				(
				input
				):
			
Mapper table Properties(
								row2
								):
							
PropertiesValues
Namerow2
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								row2
								):
							
NameTypeExpressionisNullable
SRC_Database_1Stringtrue
SRC_Schema_1Stringtrue
SRC_Server_1Stringtrue
SRC_SOR_SK_1Integertrue
SRC_Table_DI_Purpose_1Stringtrue
SRC_Table_No_1Integertrue
SRC_TableName_1Stringtrue
SRC_TableRowCount_1Integertrue
SRC_Query_1Stringtrue
SRC_Database_2Stringtrue
SRC_Schema_2Stringtrue
SRC_Server_2Stringtrue
SRC_SOR_SK_2Integertrue
SRC_Table_DI_Purpose_2Stringtrue
SRC_Table_No_2Integertrue
SRC_TableName_2Stringtrue
SRC_TableRowCount_2Integertrue
SRC_Query_2Stringtrue
SRC_Database_3Stringtrue
SRC_Schema_3Stringtrue
SRC_Server_3Stringtrue
SRC_SOR_SK_3Integertrue
SRC_Table_DI_Purpose_3Stringtrue
SRC_Table_No_3Integertrue
SRC_TableName_3Stringtrue
SRC_TableRowCount_3Integertrue
SRC_Query_3Stringtrue
SRC_Database_4Stringtrue
SRC_Schema_4Stringtrue
SRC_Server_4Stringtrue
SRC_SOR_SK_4Integertrue
SRC_Table_DI_Purpose_4Stringtrue
SRC_Table_No_4Integertrue
SRC_TableName_4Stringtrue
SRC_TableRowCount_4Integertrue
SRC_Query_4Stringtrue
SRC_Database_5Stringtrue
SRC_Schema_5Stringtrue
SRC_Server_5Stringtrue
SRC_SOR_SK_5Integertrue
SRC_Table_DI_Purpose_5Stringtrue
SRC_Table_No_5Integertrue
SRC_TableName_5Stringtrue
SRC_TableRowCount_5Integertrue
SRC_Query_5Stringtrue
SRC_Database_6Stringtrue
SRC_Schema_6Stringtrue
SRC_Server_6Stringtrue
SRC_SOR_SK_6Integertrue
SRC_Table_DI_Purpose_6Stringtrue
SRC_Table_No_6Integertrue
SRC_TableName_6Stringtrue
SRC_TableRowCount_6Integertrue
SRC_Query_6Stringtrue
SRC_Database_7Stringtrue
SRC_Schema_7Stringtrue
SRC_Server_7Stringtrue
SRC_SOR_SK_7Integertrue
SRC_Table_DI_Purpose_7Stringtrue
SRC_Table_No_7Integertrue
SRC_TableName_7Stringtrue
SRC_TableRowCount_7Integertrue
SRC_Query_7Stringtrue
SRC_Database_8Stringtrue
SRC_Schema_8Stringtrue
SRC_Server_8Stringtrue
SRC_SOR_SK_8Integertrue
SRC_Table_DI_Purpose_8Stringtrue
SRC_Table_No_8Integertrue
SRC_TableName_8Stringtrue
SRC_TableRowCount_8Integertrue
SRC_Query_8Stringtrue
SRC_Database_9Stringtrue
SRC_Schema_9Stringtrue
SRC_Server_9Stringtrue
SRC_SOR_SK_9Integertrue
SRC_Table_DI_Purpose_9Stringtrue
SRC_Table_No_9Integertrue
SRC_TableName_9Stringtrue
SRC_TableRowCount_9Integertrue
SRC_Query_9Stringtrue
SRC_Database_10Stringtrue
SRC_Schema_10Stringtrue
SRC_Server_10Stringtrue
SRC_SOR_SK_10Integertrue
SRC_Table_DI_Purpose_10Stringtrue
SRC_Table_No_10Integertrue
SRC_TableName_10Stringtrue
SRC_TableRowCount_10Integertrue
SRC_Query_10Stringtrue
TGT_Database_1Stringtrue
TGT_Schema_1Stringtrue
TGT_Server_1Stringtrue
TGT_SOR_SK_1Integertrue
TGT_Table_DI_Purpose_1Stringtrue
TGT_Table_No_1Integertrue
TGT_TableName_1Stringtrue
TGT_TableRowCount_After_1Integertrue
TGT_TableRowCount_Before_1Integertrue
TGT_RowsTotal_1Integertrue
TGT_RowsInserted_1Integertrue
TGT_RowsUpdated_1Integertrue
TGT_RowsDeleted_1Integertrue
TGT_RowsRejected_1Integertrue
TGT_Database_2Stringtrue
TGT_Schema_2Stringtrue
TGT_Server_2Stringtrue
TGT_SOR_SK_2Integertrue
TGT_Table_DI_Purpose_2Stringtrue
TGT_Table_No_2Integertrue
TGT_TableName_2Stringtrue
TGT_TableRowCount_After_2Integertrue
TGT_TableRowCount_Before_2Integertrue
TGT_RowsTotal_2Integertrue
TGT_RowsInserted_2Integertrue
TGT_RowsUpdated_2Integertrue
TGT_RowsDeleted_2Integertrue
TGT_RowsRejected_2Integertrue
TGT_Database_3Stringtrue
TGT_Schema_3Stringtrue
TGT_Server_3Stringtrue
TGT_SOR_SK_3Integertrue
TGT_Table_DI_Purpose_3Stringtrue
TGT_Table_No_3Integertrue
TGT_TableName_3Stringtrue
TGT_TableRowCount_After_3Integertrue
TGT_TableRowCount_Before_3Integertrue
TGT_RowsTotal_3Integertrue
TGT_RowsInserted_3Integertrue
TGT_RowsUpdated_3Integertrue
TGT_RowsDeleted_3Integertrue
TGT_RowsRejected_3Integertrue
TGT_Database_4Stringtrue
TGT_Schema_4Stringtrue
TGT_Server_4Stringtrue
TGT_SOR_SK_4Integertrue
TGT_Table_DI_Purpose_4Stringtrue
TGT_Table_No_4Integertrue
TGT_TableName_4Stringtrue
TGT_TableRowCount_After_4Integertrue
TGT_TableRowCount_Before_4Integertrue
TGT_RowsTotal_4Integertrue
TGT_RowsInserted_4Integertrue
TGT_RowsUpdated_4Integertrue
TGT_RowsDeleted_4Integertrue
TGT_RowsRejected_4Integertrue
TGT_Database_5Stringtrue
TGT_Schema_5Stringtrue
TGT_Server_5Stringtrue
TGT_SOR_SK_5Integertrue
TGT_Table_DI_Purpose_5Stringtrue
TGT_Table_No_5Integertrue
TGT_TableName_5Stringtrue
TGT_TableRowCount_After_5Integertrue
TGT_TableRowCount_Before_5Integertrue
TGT_RowsTotal_5Integertrue
TGT_RowsInserted_5Integertrue
TGT_RowsUpdated_5Integertrue
TGT_RowsDeleted_5Integertrue
TGT_RowsRejected_5Integertrue
TGT_Database_6Stringtrue
TGT_Schema_6Stringtrue
TGT_Server_6Stringtrue
TGT_SOR_SK_6Integertrue
TGT_Table_DI_Purpose_6Stringtrue
TGT_Table_No_6Integertrue
TGT_TableName_6Stringtrue
TGT_TableRowCount_After_6Integertrue
TGT_TableRowCount_Before_6Integertrue
TGT_RowsTotal_6Integertrue
TGT_RowsInserted_6Integertrue
TGT_RowsUpdated_6Integertrue
TGT_RowsDeleted_6Integertrue
TGT_RowsRejected_6Integertrue
TGT_Database_7Stringtrue
TGT_Schema_7Stringtrue
TGT_Server_7Stringtrue
TGT_SOR_SK_7Integertrue
TGT_Table_DI_Purpose_7Stringtrue
TGT_Table_No_7Integertrue
TGT_TableName_7Stringtrue
TGT_TableRowCount_After_7Integertrue
TGT_TableRowCount_Before_7Integertrue
TGT_RowsTotal_7Integertrue
TGT_RowsInserted_7Integertrue
TGT_RowsUpdated_7Integertrue
TGT_RowsDeleted_7Integertrue
TGT_RowsRejected_7Integertrue
TGT_Database_8Stringtrue
TGT_Schema_8Stringtrue
TGT_Server_8Stringtrue
TGT_SOR_SK_8Integertrue
TGT_Table_DI_Purpose_8Stringtrue
TGT_Table_No_8Integertrue
TGT_TableName_8Stringtrue
TGT_TableRowCount_After_8Integertrue
TGT_TableRowCount_Before_8Integertrue
TGT_RowsTotal_8Integertrue
TGT_RowsInserted_8Integertrue
TGT_RowsUpdated_8Integertrue
TGT_RowsDeleted_8Integertrue
TGT_RowsRejected_8Integertrue
TGT_Database_9Stringtrue
TGT_Schema_9Stringtrue
TGT_Server_9Stringtrue
TGT_SOR_SK_9Integertrue
TGT_Table_DI_Purpose_9Stringtrue
TGT_Table_No_9Integertrue
TGT_TableName_9Stringtrue
TGT_TableRowCount_After_9Integertrue
TGT_TableRowCount_Before_9Integertrue
TGT_RowsTotal_9Integertrue
TGT_RowsInserted_9Integertrue
TGT_RowsUpdated_9Integertrue
TGT_RowsDeleted_9Integertrue
TGT_RowsRejected_9Integertrue
TGT_Database_10Stringtrue
TGT_Schema_10Stringtrue
TGT_Server_10Stringtrue
TGT_SOR_SK_10Integertrue
TGT_Table_DI_Purpose_10Stringtrue
TGT_Table_No_10Integertrue
TGT_TableName_10Stringtrue
TGT_TableRowCount_After_10Integertrue
TGT_TableRowCount_Before_10Integertrue
TGT_RowsTotal_10Integertrue
TGT_RowsInserted_10Integertrue
TGT_RowsUpdated_10Integertrue
TGT_RowsDeleted_10Integertrue
TGT_RowsRejected_10Integertrue
DI_Job_PIDStringtrue
DI_Create_Datejava.util.Datetrue
DI_Modify_Datejava.util.Datetrue

Constraint Table Entries(
								row2
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_2
				(
				output
				):
			
Mapper table Properties(
								DI_Flow_RowCounts_SRC
								):
							
PropertiesValues
NameDI_Flow_RowCounts_SRC
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								DI_Flow_RowCounts_SRC
								):
							
NameTypeExpressionisNullable
SRC_Database_1Stringrow2.SRC_Database_1true
SRC_Database_2Stringrow2.SRC_Database_2true
SRC_Database_3Stringrow2.SRC_Database_3true
SRC_Database_4Stringrow2.SRC_Database_4true
SRC_Database_5Stringrow2.SRC_Database_5true
SRC_Database_6Stringrow2.SRC_Database_6true
SRC_Database_7Stringrow2.SRC_Database_7true
SRC_Database_8Stringrow2.SRC_Database_8true
SRC_Database_9Stringrow2.SRC_Database_9true
SRC_Database_10Stringrow2.SRC_Database_10true
SRC_Schema_1Stringrow2.SRC_Schema_1true
SRC_Schema_2Stringrow2.SRC_Schema_2true
SRC_Schema_3Stringrow2.SRC_Schema_3true
SRC_Schema_4Stringrow2.SRC_Schema_4true
SRC_Schema_5Stringrow2.SRC_Schema_5true
SRC_Schema_6Stringrow2.SRC_Schema_6true
SRC_Schema_7Stringrow2.SRC_Schema_7true
SRC_Schema_8Stringrow2.SRC_Schema_8true
SRC_Schema_9Stringrow2.SRC_Schema_9true
SRC_Schema_10Stringrow2.SRC_Schema_10true
SRC_Server_1Stringrow2.SRC_Server_1true
SRC_Server_2Stringrow2.SRC_Server_2true
SRC_Server_3Stringrow2.SRC_Server_3true
SRC_Server_4Stringrow2.SRC_Server_4true
SRC_Server_5Stringrow2.SRC_Server_5true
SRC_Server_6Stringrow2.SRC_Server_6true
SRC_Server_7Stringrow2.SRC_Server_7true
SRC_Server_8Stringrow2.SRC_Server_8true
SRC_Server_9Stringrow2.SRC_Server_9true
SRC_Server_10Stringrow2.SRC_Server_10true
SRC_SOR_SK_1Integerrow2.SRC_SOR_SK_1true
SRC_SOR_SK_2Integerrow2.SRC_SOR_SK_2true
SRC_SOR_SK_3Integerrow2.SRC_SOR_SK_3true
SRC_SOR_SK_4Integerrow2.SRC_SOR_SK_4true
SRC_SOR_SK_5Integerrow2.SRC_SOR_SK_5true
SRC_SOR_SK_6Integerrow2.SRC_SOR_SK_6true
SRC_SOR_SK_7Integerrow2.SRC_SOR_SK_7true
SRC_SOR_SK_8Integerrow2.SRC_SOR_SK_8true
SRC_SOR_SK_9Integerrow2.SRC_SOR_SK_9true
SRC_SOR_SK_10Integerrow2.SRC_SOR_SK_10true
SRC_Table_DI_Purpose_1Stringrow2.SRC_Table_DI_Purpose_1true
SRC_Table_DI_Purpose_2Stringrow2.SRC_Table_DI_Purpose_2true
SRC_Table_DI_Purpose_3Stringrow2.SRC_Table_DI_Purpose_3true
SRC_Table_DI_Purpose_4Stringrow2.SRC_Table_DI_Purpose_4true
SRC_Table_DI_Purpose_5Stringrow2.SRC_Table_DI_Purpose_5true
SRC_Table_DI_Purpose_6Stringrow2.SRC_Table_DI_Purpose_6true
SRC_Table_DI_Purpose_7Stringrow2.SRC_Table_DI_Purpose_7true
SRC_Table_DI_Purpose_8Stringrow2.SRC_Table_DI_Purpose_8true
SRC_Table_DI_Purpose_9Stringrow2.SRC_Table_DI_Purpose_9true
SRC_Table_DI_Purpose_10Stringrow2.SRC_Table_DI_Purpose_10true
SRC_Table_No_1Integerrow2.SRC_Table_No_1true
SRC_Table_No_2Integerrow2.SRC_Table_No_2true
SRC_Table_No_3Integerrow2.SRC_Table_No_3true
SRC_Table_No_4Integerrow2.SRC_Table_No_4true
SRC_Table_No_5Integerrow2.SRC_Table_No_5true
SRC_Table_No_6Integerrow2.SRC_Table_No_6true
SRC_Table_No_7Integerrow2.SRC_Table_No_7true
SRC_Table_No_8Integerrow2.SRC_Table_No_8true
SRC_Table_No_9Integerrow2.SRC_Table_No_9true
SRC_Table_No_10Integerrow2.SRC_Table_No_10true
SRC_TableName_1Stringrow2.SRC_TableName_1true
SRC_TableName_2Stringrow2.SRC_TableName_2true
SRC_TableName_3Stringrow2.SRC_TableName_3true
SRC_TableName_4Stringrow2.SRC_TableName_4true
SRC_TableName_5Stringrow2.SRC_TableName_5true
SRC_TableName_6Stringrow2.SRC_TableName_6true
SRC_TableName_7Stringrow2.SRC_TableName_7true
SRC_TableName_8Stringrow2.SRC_TableName_8true
SRC_TableName_9Stringrow2.SRC_TableName_9true
SRC_TableName_10Stringrow2.SRC_TableName_10true
SRC_TableRowCount_1Integerrow2.SRC_TableRowCount_1true
SRC_TableRowCount_2Integerrow2.SRC_TableRowCount_2true
SRC_TableRowCount_3Integerrow2.SRC_TableRowCount_3true
SRC_TableRowCount_4Integerrow2.SRC_TableRowCount_4true
SRC_TableRowCount_5Integerrow2.SRC_TableRowCount_5true
SRC_TableRowCount_6Integerrow2.SRC_TableRowCount_6true
SRC_TableRowCount_7Integerrow2.SRC_TableRowCount_7true
SRC_TableRowCount_8Integerrow2.SRC_TableRowCount_8true
SRC_TableRowCount_9Integerrow2.SRC_TableRowCount_9true
SRC_TableRowCount_10Integerrow2.SRC_TableRowCount_10true
SRC_Query_1Stringrow2.SRC_Query_1true
SRC_Query_2Stringrow2.SRC_Query_2true
SRC_Query_3Stringrow2.SRC_Query_3true
SRC_Query_4Stringrow2.SRC_Query_4true
SRC_Query_5Stringrow2.SRC_Query_5true
SRC_Query_6Stringrow2.SRC_Query_6true
SRC_Query_7Stringrow2.SRC_Query_7true
SRC_Query_8Stringrow2.SRC_Query_8true
SRC_Query_9Stringrow2.SRC_Query_9true
SRC_Query_10Stringrow2.SRC_Query_10true
DI_Job_PIDStringpidfalse
DI_Create_Datejava.util.DateTalendDate.getCurrentDate() false
DI_Modify_Datejava.util.DateTalendDate.getCurrentDate()false

Constraint Table Entries(
								DI_Flow_RowCounts_SRC
								):
							
NameTypeExpressionisNullable

Mapper table Properties(
								DI_Flow_RowCounts_TGT
								):
							
PropertiesValues
NameDI_Flow_RowCounts_TGT
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								DI_Flow_RowCounts_TGT
								):
							
NameTypeExpressionisNullable
TGT_Database_1Stringrow2.TGT_Database_1true
TGT_Database_2Stringrow2.TGT_Database_2true
TGT_Database_3Stringrow2.TGT_Database_3true
TGT_Database_4Stringrow2.TGT_Database_4true
TGT_Database_5Stringrow2.TGT_Database_5true
TGT_Database_6Stringrow2.TGT_Database_6true
TGT_Database_7Stringrow2.TGT_Database_7true
TGT_Database_8Stringrow2.TGT_Database_8true
TGT_Database_9Stringrow2.TGT_Database_9true
TGT_Database_10Stringrow2.TGT_Database_10true
TGT_Schema_1Stringrow2.TGT_Schema_1true
TGT_Schema_2Stringrow2.TGT_Schema_2true
TGT_Schema_3Stringrow2.TGT_Schema_3true
TGT_Schema_4Stringrow2.TGT_Schema_4true
TGT_Schema_5Stringrow2.TGT_Schema_5true
TGT_Schema_6Stringrow2.TGT_Schema_6true
TGT_Schema_7Stringrow2.TGT_Schema_7true
TGT_Schema_8Stringrow2.TGT_Schema_8true
TGT_Schema_9Stringrow2.TGT_Schema_9true
TGT_Schema_10Stringrow2.TGT_Schema_10true
TGT_Server_1Stringrow2.TGT_Server_1true
TGT_Server_2Stringrow2.TGT_Server_2true
TGT_Server_3Stringrow2.TGT_Server_3true
TGT_Server_4Stringrow2.TGT_Server_4true
TGT_Server_5Stringrow2.TGT_Server_5true
TGT_Server_6Stringrow2.TGT_Server_6true
TGT_Server_7Stringrow2.TGT_Server_7true
TGT_Server_8Stringrow2.TGT_Server_8true
TGT_Server_9Stringrow2.TGT_Server_9true
TGT_Server_10Stringrow2.TGT_Server_10true
TGT_SOR_SK_1Integerrow2.TGT_SOR_SK_1true
TGT_SOR_SK_2Integerrow2.TGT_SOR_SK_2true
TGT_SOR_SK_3Integerrow2.TGT_SOR_SK_3true
TGT_SOR_SK_4Integerrow2.TGT_SOR_SK_4true
TGT_SOR_SK_5Integerrow2.TGT_SOR_SK_5true
TGT_SOR_SK_6Integerrow2.TGT_SOR_SK_6true
TGT_SOR_SK_7Integerrow2.TGT_SOR_SK_7true
TGT_SOR_SK_8Integerrow2.TGT_SOR_SK_8true
TGT_SOR_SK_9Integerrow2.TGT_SOR_SK_9true
TGT_SOR_SK_10Integerrow2.TGT_SOR_SK_10true
TGT_Table_DI_Purpose_1Stringrow2.TGT_Table_DI_Purpose_1true
TGT_Table_DI_Purpose_2Stringrow2.TGT_Table_DI_Purpose_2true
TGT_Table_DI_Purpose_3Stringrow2.TGT_Table_DI_Purpose_3true
TGT_Table_DI_Purpose_4Stringrow2.TGT_Table_DI_Purpose_4true
TGT_Table_DI_Purpose_5Stringrow2.TGT_Table_DI_Purpose_5true
TGT_Table_DI_Purpose_6Stringrow2.TGT_Table_DI_Purpose_6true
TGT_Table_DI_Purpose_7Stringrow2.TGT_Table_DI_Purpose_7true
TGT_Table_DI_Purpose_8Stringrow2.TGT_Table_DI_Purpose_8true
TGT_Table_DI_Purpose_9Stringrow2.TGT_Table_DI_Purpose_9true
TGT_Table_DI_Purpose_10Stringrow2.TGT_Table_DI_Purpose_10true
TGT_Table_No_1Integerrow2.TGT_Table_No_1true
TGT_Table_No_2Integerrow2.TGT_Table_No_2true
TGT_Table_No_3Integerrow2.TGT_Table_No_3true
TGT_Table_No_4Integerrow2.TGT_Table_No_4true
TGT_Table_No_5Integerrow2.TGT_Table_No_5true
TGT_Table_No_6Integerrow2.TGT_Table_No_6true
TGT_Table_No_7Integerrow2.TGT_Table_No_7true
TGT_Table_No_8Integerrow2.TGT_Table_No_8true
TGT_Table_No_9Integerrow2.TGT_Table_No_9true
TGT_Table_No_10Integerrow2.TGT_Table_No_10true
TGT_TableName_1Stringrow2.TGT_TableName_1true
TGT_TableName_2Stringrow2.TGT_TableName_2true
TGT_TableName_3Stringrow2.TGT_TableName_3true
TGT_TableName_4Stringrow2.TGT_TableName_4true
TGT_TableName_5Stringrow2.TGT_TableName_5true
TGT_TableName_6Stringrow2.TGT_TableName_6true
TGT_TableName_7Stringrow2.TGT_TableName_7true
TGT_TableName_8Stringrow2.TGT_TableName_8true
TGT_TableName_9Stringrow2.TGT_TableName_9true
TGT_TableName_10Stringrow2.TGT_TableName_10true
TGT_TableRowCount_After_1Integerrow2.TGT_TableRowCount_After_1true
TGT_TableRowCount_After_2Integerrow2.TGT_TableRowCount_After_2true
TGT_TableRowCount_After_3Integerrow2.TGT_TableRowCount_After_3true
TGT_TableRowCount_After_4Integerrow2.TGT_TableRowCount_After_4true
TGT_TableRowCount_After_5Integerrow2.TGT_TableRowCount_After_5true
TGT_TableRowCount_After_6Integerrow2.TGT_TableRowCount_After_6true
TGT_TableRowCount_After_7Integerrow2.TGT_TableRowCount_After_7true
TGT_TableRowCount_After_8Integerrow2.TGT_TableRowCount_After_8true
TGT_TableRowCount_After_9Integerrow2.TGT_TableRowCount_After_9true
TGT_TableRowCount_After_10Integerrow2.TGT_TableRowCount_After_10true
TGT_TableRowCount_Before_1Integerrow2.TGT_TableRowCount_Before_1true
TGT_TableRowCount_Before_2Integerrow2.TGT_TableRowCount_Before_2true
TGT_TableRowCount_Before_3Integerrow2.TGT_TableRowCount_Before_3true
TGT_TableRowCount_Before_4Integerrow2.TGT_TableRowCount_Before_4true
TGT_TableRowCount_Before_5Integerrow2.TGT_TableRowCount_Before_5true
TGT_TableRowCount_Before_6Integerrow2.TGT_TableRowCount_Before_6true
TGT_TableRowCount_Before_7Integerrow2.TGT_TableRowCount_Before_7true
TGT_TableRowCount_Before_8Integerrow2.TGT_TableRowCount_Before_8true
TGT_TableRowCount_Before_9Integerrow2.TGT_TableRowCount_Before_9true
TGT_TableRowCount_Before_10Integerrow2.TGT_TableRowCount_Before_10true
TGT_RowsTotal_1Integerrow2.TGT_RowsTotal_1true
TGT_RowsTotal_2Integerrow2.TGT_RowsTotal_2true
TGT_RowsTotal_3Integerrow2.TGT_RowsTotal_3true
TGT_RowsTotal_4Integerrow2.TGT_RowsTotal_4true
TGT_RowsTotal_5Integerrow2.TGT_RowsTotal_5true
TGT_RowsTotal_6Integerrow2.TGT_RowsTotal_6true
TGT_RowsTotal_7Integerrow2.TGT_RowsTotal_7true
TGT_RowsTotal_8Integerrow2.TGT_RowsTotal_8true
TGT_RowsTotal_9Integerrow2.TGT_RowsTotal_9true
TGT_RowsTotal_10Integerrow2.TGT_RowsTotal_10true
TGT_RowsInserted_1Integerrow2.TGT_RowsInserted_1true
TGT_RowsInserted_2Integerrow2.TGT_RowsInserted_2true
TGT_RowsInserted_3Integerrow2.TGT_RowsInserted_3true
TGT_RowsInserted_4Integerrow2.TGT_RowsInserted_4true
TGT_RowsInserted_5Integerrow2.TGT_RowsInserted_5true
TGT_RowsInserted_6Integerrow2.TGT_RowsInserted_6true
TGT_RowsInserted_7Integerrow2.TGT_RowsInserted_7true
TGT_RowsInserted_8Integerrow2.TGT_RowsInserted_8true
TGT_RowsInserted_9Integerrow2.TGT_RowsInserted_9true
TGT_RowsInserted_10Integerrow2.TGT_RowsInserted_10true
TGT_RowsUpdated_1Integerrow2.TGT_RowsUpdated_1true
TGT_RowsUpdated_2Integerrow2.TGT_RowsUpdated_2true
TGT_RowsUpdated_3Integerrow2.TGT_RowsUpdated_3true
TGT_RowsUpdated_4Integerrow2.TGT_RowsUpdated_4true
TGT_RowsUpdated_5Integerrow2.TGT_RowsUpdated_5true
TGT_RowsUpdated_6Integerrow2.TGT_RowsUpdated_6true
TGT_RowsUpdated_7Integerrow2.TGT_RowsUpdated_7true
TGT_RowsUpdated_8Integerrow2.TGT_RowsUpdated_8true
TGT_RowsUpdated_9Integerrow2.TGT_RowsUpdated_9true
TGT_RowsUpdated_10Integerrow2.TGT_RowsUpdated_10true
TGT_RowsDeleted_1Integerrow2.TGT_RowsDeleted_1true
TGT_RowsDeleted_2Integerrow2.TGT_RowsDeleted_2true
TGT_RowsDeleted_3Integerrow2.TGT_RowsDeleted_3true
TGT_RowsDeleted_4Integerrow2.TGT_RowsDeleted_4true
TGT_RowsDeleted_5Integerrow2.TGT_RowsDeleted_5true
TGT_RowsDeleted_6Integerrow2.TGT_RowsDeleted_6true
TGT_RowsDeleted_7Integerrow2.TGT_RowsDeleted_7true
TGT_RowsDeleted_8Integerrow2.TGT_RowsDeleted_8true
TGT_RowsDeleted_9Integerrow2.TGT_RowsDeleted_9true
TGT_RowsDeleted_10Integerrow2.TGT_RowsDeleted_10true
TGT_RowsRejected_1Integerrow2.TGT_RowsRejected_1true
TGT_RowsRejected_2Integerrow2.TGT_RowsRejected_2true
TGT_RowsRejected_3Integerrow2.TGT_RowsRejected_3true
TGT_RowsRejected_4Integerrow2.TGT_RowsRejected_4true
TGT_RowsRejected_5Integerrow2.TGT_RowsRejected_5true
TGT_RowsRejected_6Integerrow2.TGT_RowsRejected_6true
TGT_RowsRejected_7Integerrow2.TGT_RowsRejected_7true
TGT_RowsRejected_8Integerrow2.TGT_RowsRejected_8true
TGT_RowsRejected_9Integerrow2.TGT_RowsRejected_9true
TGT_RowsRejected_10Integerrow2.TGT_RowsRejected_10true
DI_Job_PIDStringpidfalse
DI_Create_Datejava.util.DateTalendDate.getCurrentDate()false
DI_Modify_Datejava.util.DateTalendDate.getCurrentDate()false

Constraint Table Entries(
								DI_Flow_RowCounts_TGT
								):
							
NameTypeExpressionisNullable

Mapper table Properties(
								table_details_email
								):
							
PropertiesValues
Nametable_details_email
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								table_details_email
								):
							
NameTypeExpressionisNullable
Job_PIDStringpidtrue
Run_Datejava.util.DateTalendDate.getCurrentDate()true
TargetTableRowCount_BeforeIntegercontext.TGT_TableRowCount_Before_1true
TargetTableRowCount_AfterIntegerrow2.TGT_TableRowCount_After_1true
SourceTableNameStringrow2.SRC_TableName_1 true
TargetTableNameStringrow2.TGT_TableName_1 true
SourceTableRowCountIntegerrow2.SRC_TableRowCount_1true

Constraint Table Entries(
								table_details_email
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_2
				(
				var
				):
			
Mapper table Properties(
								Var
								):
							
PropertiesValues
NameVar
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Component  									tMap

								     							UNIQUE NAMEtMap_3INPUT(S)tDBInput_2
LABEL__UNIQUE_NAME__OUTPUT(S)tFlowMeter_9



Component Parameters:
PropertiesValues
tStatCatcher Statistics
false
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
true
Show Information
false
Comment
Map the data and add the appropriate tracking data to be loaded into the staging database.
Use an existing validation rule
false

Mapper table for tMap_3
				(
				input
				):
			
Mapper table Properties(
								PS_UM_GLQ_ACCTA
								):
							
PropertiesValues
NamePS_UM_GLQ_ACCTA
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								PS_UM_GLQ_ACCTA
								):
							
NameTypeExpressionisNullable
FISCAL_YEARintfalse
ACCOUNTStringfalse
DESCRStringfalse
DESCRSHORTStringfalse
EFF_STATUSStringfalse
UM_ACCT_CATStringfalse
UM_ACCT_CAT_DStringfalse
UM_ACCT_DTLStringfalse
UM_ACCT_DTL_DStringfalse
UM_ACCT_GRPStringfalse
UM_ACCT_GRP_DStringfalse
UM_ACCT_GRP_SHRTStringfalse
UM_ACCT_GRP_SHRT_DStringfalse
UM_ACCT_SUBCATStringfalse
UM_ACCT_SUBCAT_DStringfalse
UM_ACCT_SUMStringfalse
UM_ACCT_SUM_DStringfalse
UM_ACCT_SUM_SHRTStringfalse
UM_ACCT_SUM_SHRT_DStringfalse
UM_ACCT_TYPEStringfalse
UM_ACCT_TYPE_DStringfalse
UM_RPT_CATStringfalse
UM_RPT_CAT_DStringfalse
UM_RPT_GRPStringfalse
UM_RPT_GRP_DStringfalse
UM_RPT_TYPEStringfalse
UM_RPT_TYPE_DStringfalse
UM_ACCT_CASH_FLWStringfalse
UM_ACCT_CASH_FLW_DStringfalse

Constraint Table Entries(
								PS_UM_GLQ_ACCTA
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_3
				(
				output
				):
			
Mapper table Properties(
								FN_UM_GLQ_ACCTA
								):
							
PropertiesValues
NameFN_UM_GLQ_ACCTA
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								FN_UM_GLQ_ACCTA
								):
							
NameTypeExpressionisNullable
FISCAL_YEARfloatPS_UM_GLQ_ACCTA.FISCAL_YEAR false
ACCOUNTStringPS_UM_GLQ_ACCTA.ACCOUNT false
DESCRStringPS_UM_GLQ_ACCTA.DESCR false
DESCRSHORTStringPS_UM_GLQ_ACCTA.DESCRSHORT false
EFF_STATUSStringPS_UM_GLQ_ACCTA.EFF_STATUS false
UM_ACCT_CATStringPS_UM_GLQ_ACCTA.UM_ACCT_CAT false
UM_ACCT_CAT_DStringPS_UM_GLQ_ACCTA.UM_ACCT_CAT_D false
UM_ACCT_DTLStringPS_UM_GLQ_ACCTA.UM_ACCT_DTL false
UM_ACCT_DTL_DStringPS_UM_GLQ_ACCTA.UM_ACCT_DTL_D false
UM_ACCT_GRPStringPS_UM_GLQ_ACCTA.UM_ACCT_GRP false
UM_ACCT_GRP_DStringPS_UM_GLQ_ACCTA.UM_ACCT_GRP_D false
UM_ACCT_GRP_SHRTStringPS_UM_GLQ_ACCTA.UM_ACCT_GRP_SHRT false
UM_ACCT_GRP_SHRT_DStringPS_UM_GLQ_ACCTA.UM_ACCT_GRP_SHRT_D false
UM_ACCT_SUBCATStringPS_UM_GLQ_ACCTA.UM_ACCT_SUBCAT false
UM_ACCT_SUBCAT_DStringPS_UM_GLQ_ACCTA.UM_ACCT_SUBCAT_D false
UM_ACCT_SUMStringPS_UM_GLQ_ACCTA.UM_ACCT_SUM false
UM_ACCT_SUM_DStringPS_UM_GLQ_ACCTA.UM_ACCT_SUM_D false
UM_ACCT_SUM_SHRTStringPS_UM_GLQ_ACCTA.UM_ACCT_SUM_SHRT false
UM_ACCT_SUM_SHRT_DStringPS_UM_GLQ_ACCTA.UM_ACCT_SUM_SHRT_D false
UM_ACCT_TYPEStringPS_UM_GLQ_ACCTA.UM_ACCT_TYPE false
UM_ACCT_TYPE_DStringPS_UM_GLQ_ACCTA.UM_ACCT_TYPE_D false
UM_RPT_CATStringPS_UM_GLQ_ACCTA.UM_RPT_CAT false
UM_RPT_CAT_DStringPS_UM_GLQ_ACCTA.UM_RPT_CAT_D false
UM_RPT_GRPStringPS_UM_GLQ_ACCTA.UM_RPT_GRP false
UM_RPT_GRP_DStringPS_UM_GLQ_ACCTA.UM_RPT_GRP_D false
UM_RPT_TYPEStringPS_UM_GLQ_ACCTA.UM_RPT_TYPE false
UM_RPT_TYPE_DStringPS_UM_GLQ_ACCTA.UM_RPT_TYPE_D false
UM_ACCT_CASH_FLWStringPS_UM_GLQ_ACCTA.UM_ACCT_CASH_FLW false
UM_ACCT_CASH_FLW_DStringPS_UM_GLQ_ACCTA.UM_ACCT_CASH_FLW_D false
DI_Job_PIDStringpidfalse
DI_Create_Datejava.util.DateTalendDate.getCurrentDate() false
DI_Modified_Datejava.util.DateTalendDate.getCurrentDate() false

Constraint Table Entries(
								FN_UM_GLQ_ACCTA
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_3
				(
				var
				):
			
Mapper table Properties(
								Var
								):
							
PropertiesValues
NameVar
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Component  									tMap

								     							UNIQUE NAMEtMap_7INPUT(S)tDBInput_6
LABELMap_TGT_Count_BeforeOUTPUT(S)tJavaRow_4



Component Parameters:
PropertiesValues
tStatCatcher Statistics
true
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
true
Show Information
false
Comment
Map the count.
Use an existing validation rule
false

Mapper table for tMap_7
				(
				input
				):
			
Mapper table Properties(
								get_TGT_RowCount_Before
								):
							
PropertiesValues
Nameget_TGT_RowCount_Before
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								get_TGT_RowCount_Before
								):
							
NameTypeExpressionisNullable
TGTCountBeforeIntegertrue

Constraint Table Entries(
								get_TGT_RowCount_Before
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_7
				(
				output
				):
			
Mapper table Properties(
								put_count
								):
							
PropertiesValues
Nameput_count
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								put_count
								):
							
NameTypeExpressionisNullable
TGTCountBeforeIntegerget_TGT_RowCount_Before.TGTCountBefore true

Constraint Table Entries(
								put_count
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_7
				(
				var
				):
			
Mapper table Properties(
								Var
								):
							
PropertiesValues
NameVar
Matching-mode
isMinimizedtrue
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable