Created by Miki Yanagi, last modified on Aug 28, 2019

Generated documentation
Jobs
Generated by Talend Open Studio for Data Integration


Project NameFN_StagingGENERATION DATEAug 26, 2019 10:00:41 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
NameFNSTG001
Authoruser@talend.com
Version1.0
PurposeFN_Staging_Job_001
Status
DescriptionFirst job in the FN staging jobset. This is the master control job.
CreationMay 23, 2019 10:41:47 AM
ModificationAug 26, 2019 9:11:52 AM

Preview Picture


No image available
tContextLoad_1tFileInputDelimited_1tJava_2tJava_3tRunJob_1tRunJob_2

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
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
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringsaDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringDI_CNTLDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password********DI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_StringlocalhostDI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password********SS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringsaSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringTalendStagingSS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_StringlocalhostSS_Staging_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
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
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_DEVDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfndev.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNDEVFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_DEVSS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_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


ContextPRD

NamePromptNeed Prompt?TypeValueSource
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
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_PRDDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfnprd.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNPRDFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_PRDSS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_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
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
DI_CNTL_SchemaDI_CNTL_Schema?falseid_StringdboDI_CNTL_Context
DI_CNTL_LoginDI_CNTL_Login?falseid_StringPS_TO_DMDI_CNTL_Context
DI_CNTL_DatabaseDI_CNTL_Database?falseid_StringUMS_DI_CNTL_TSTDI_CNTL_Context
DI_CNTL_PasswordDI_CNTL_Password?falseid_Password**********DI_CNTL_Context
DI_CNTL_ServerDI_CNTL_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduDI_CNTL_Context
DI_CNTL_AdditionalParamsDI_CNTL_AdditionalParams?falseid_StringDI_CNTL_Context
DI_CNTL_PortDI_CNTL_Port?falseid_String1433DI_CNTL_Context
FNContext_ServerFNContext_Server?falseid_Stringfntst.db.its.maine.eduFNContext
FNContext_ServiceNameFNContext_ServiceName?falseid_StringFNTSTFNContext
FNContext_SchemaFNContext_Schema?falseid_StringSYSADMFNContext
FNContext_PortFNContext_Port?falseid_String1521FNContext
FNContext_PasswordFNContext_Password?falseid_Password**********FNContext
FNContext_AdditionalParamsFNContext_AdditionalParams?falseid_StringFNContext
FNContext_LoginFNContext_Login?falseid_StringDARTSFNContext
SSS_Context_AdditionalParamsSSS_Context_AdditionalParams?falseid_StringSS_Staging_Context
SSS_Context_PasswordSSS_Context_Password?falseid_Password**********SS_Staging_Context
SSS_Context_LoginSSS_Context_Login?falseid_StringPS_TO_DMSS_Staging_Context
SSS_Context_DatabaseSSS_Context_Database?falseid_StringUMS_STAGING_TSTSS_Staging_Context
SSS_Context_SchemaSSS_Context_Schema?falseid_StringdboSS_Staging_Context
SSS_Context_PortSSS_Context_Port?falseid_String1433SS_Staging_Context
SSS_Context_ServerSSS_Context_Server?falseid_Stringwv-o-ums-sqldev.uad.maine.eduSS_Staging_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
tContextLoad_1tContextLoad
tFileInputDelimited_1tFileInputDelimited
tJava_2tJava
tJava_3tJava
tRunJob_1tRunJob
tRunJob_2tRunJob

Components Description

Component   tContextLoad

      UNIQUE NAMEtContextLoad_1INPUT(S)tFileInputDelimited_1
LABELContext_LoadOUTPUT(S)tJava_3

Component Parameters:
PropertiesValues
Unique NametContextLoad_1
Component NametContextLoad
Version0.101 (ALPHA)
FamilyMisc
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tContextLoad
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
If a variable loaded, but not in the contextWarning
If a variable in the context, but not loadedWarning
Print operationsfalse
Disable errorsfalse
Disable warningstrue
Disable infotrue
Die on errorfalse
Label formatContext_Load
Hint format<b>_FNS00_dbConnect_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentLoads the job specific run time parameters to the named context variables listed in the csv file.
Use an existing validation rulefalse
Validation Rule Type

Schema for tContextLoad_1 :
ColumnKeyTypeLengthPrecisionNullableComment
keyfalseString255true
valuefalseString255true

Original Function Parameters:
Component   tFileInputDelimited

      UNIQUE NAMEtFileInputDelimited_1INPUT(S)tJava_2
LABELFY_SettingsOUTPUT(S)tContextLoad_1

Component Parameters:
PropertiesValues
Unique NametFileInputDelimited_1
Component NametFileInputDelimited
Version0.102 (ALPHA)
FamilyFile/Input
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tFileInputDelimited
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: DELIM:FY_Settings
REPOSITORY_ALLOW_AUTO_SWITCHtrue
Schemarepository: DELIM:FY_Settings - metadata
File name/Stream"E:/TalendData/DartsRunControl/FNS_Run_Parameters.csv"
CSV optionsfalse
Row Separator"\n"
CSV Row Separator"\n"
Field Separator","
Escape char"""
Text enclosure"""
Header1
Footer0
Limit
Skip empty rowsfalse
Uncompress as zip filefalse
Die on errorfalse
Schemarepository: DELIM:FY_Settings - metadata
!!!TEMP_DIR.NAME!!!"E:/Talend Projects"
Advanced separator (for numbers)false
Thousands separator","
Decimal separator"."
Extract lines at randomfalse
Number of lines10
Trim all columnsfalse
Check column to trim[{SCHEMA_COLUMN=key, TRIM=false}, {SCHEMA_COLUMN=value, TRIM=false}]
Check each row structure against schemafalse
Check datefalse
Encoding"US-ASCII"
Split row before fieldfalse
Permit hexadecimal (0xNNN) or octal (0NNNN) for numeric typesfalse
Decode table[{SCHEMA_COLUMN=key, DECODE=false}, {SCHEMA_COLUMN=value, DECODE=false}]
!!!DESTINATION.NAME!!!
Min column number of optimize code100
Label formatFY_Settings
Hint format<b>_FY_Settings_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentReads the job runtime parameters
Use an existing validation rulefalse
Validation Rule Type

Schema for metadata :
ColumnKeyTypeLengthPrecisionNullableComment
keyfalseString255true
valuefalseString255true

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_2INPUT(S)none
LABELClear_FN_Job_ContextsOUTPUT(S)tFileInputDelimited_1

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)tContextLoad_1
LABELSet_FN_Job_Contexts_For_Job_StepOUTPUT(S)tRunJob_1

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// ***** PRINT Job Specific Contexts Below ***** // System.out.println(" "); System.out.println("Current run variables:"); System.out.println("context.FY_Start = " + context.FY_Start ); System.out.println("context.FY_End = " + context.FY_End ); 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
CommentPrints the job specific context variables to the system console. Useful for debugging.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_3 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tRunJob

      UNIQUE NAMEtRunJob_1INPUT(S)tJava_3
LABELFNS00_dbConnectOUTPUT(S)tRunJob_2

Component Parameters:
PropertiesValues
Unique NametRunJob_1
Component NametRunJob
Version0.101 (ALPHA)
FamilySystem|Orchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tRunJob
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
Use dynamic jobfalse
Context job
JobFNS00_dbConnect
ContextDefault
Use an independent process to run subjobfalse
Die on child errortrue
Transmit whole contexttrue
Context Param[]
Propagate the child result to the output schemafalse
Print Parametersfalse
Transmit original context value(if uncheck, there will convert context value to string type before transmiting.)true
Label formatFNS00_dbConnect
Hint format<b>_FNS00_dbConnect_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentExecutes FNS00_dbConnect to check database connections.
Use an existing validation rulefalse
Validation Rule Type

Schema for tRunJob_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tRunJob

      UNIQUE NAMEtRunJob_2INPUT(S)tRunJob_1
LABELFNS01_Main_LoopOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametRunJob_2
Component NametRunJob
Version0.101 (ALPHA)
FamilySystem|Orchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tRunJob
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
Use dynamic jobfalse
Context job
JobFNS01_Main_Loop
ContextDefault
Use an independent process to run subjobfalse
Die on child errortrue
Transmit whole contexttrue
Context Param[]
Propagate the child result to the output schemafalse
Print Parametersfalse
Transmit original context value(if uncheck, there will convert context value to string type before transmiting.)true
Label formatFNS01_Main_Loop
Hint format<b>_FNS01_Main_Loop_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentExecutes the main loop.
Use an existing validation rulefalse
Validation Rule Type

Schema for tRunJob_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:

Attachments:

image2019-8-28_10-33-37.png (image/png)