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


Project NameFN_StagingGENERATION DATEAug 26, 2019 10:00:39 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
NameFNS01_Main_Loop
Authoruser@talend.com
Version1.0
PurposeMain Loop for FN Staging
StatusDEV
DescriptionEach staging table is built by its own subjob. Subjob execution occurs from here.
CreationOct 11, 2018 7:56:49 AM
ModificationAug 26, 2019 9:11:21 AM

Preview Picture


No image available
tDBInput_1tDBOutput_1tDBOutput_2tFlowToIterate_1tJavaFlex_1tJava_1tJava_2tMap_1tMap_4tRunJob_1tRunJob_3tSendMail_1tSetGlobalVar_1

Settings

Extra settings

NameValue
COMP_DEFAULT_FILE_DIR
Multi thread executiontrue
Implicit tContextLoadfalse


Status & Logs

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


Context List

ContextDefault

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


ContextDEV

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


ContextFNPRD

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


ContextPRD

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


ContextTST

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




Component List

Component NameComponent Type
tDBInput_1tMSSqlInput
tDBOutput_1tMSSqlOutput
tDBOutput_2tMSSqlOutput
tFlowToIterate_1tFlowToIterate
tJavaFlex_1tJavaFlex
tJava_1tJava
tJava_2tJava
tMap_1tMap
tMap_4tMap
tRunJob_1tRunJob
tRunJob_3tRunJob
tSendMail_1tSendMail
tSetGlobalVar_1tSetGlobalVar

Components Description

Component   tMSSqlInput

      UNIQUE NAMEtDBInput_1INPUT(S)tSetGlobalVar_1
LABEL__TABLE__OUTPUT(S)tFlowToIterate_1,  tSendMail_1

Component Parameters:
PropertiesValues
DatabasetMSSqlInput
Unique NametDBInput_1
Component NametMSSqlInput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tMSSqlInput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Use an existing connectionfalse
Component List
Property Typerepository: DB (MSSQL):DI_CNTL
Hostcontext.DI_CNTL_Server
JDBC ProviderMSSQL_PROP
Database DriverMSSQL
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Table Name"Audit_Table_Email"
Query TypeBuilt-In
Guess Schema""
Query"SELECT dbo.Audit_Table_Email.Audit_Table_ID, dbo.Audit_Table_Email.Job_PID, dbo.Audit_Table_Email.Run_Date, dbo.Audit_Table_Email.SourceTableName, dbo.Audit_Table_Email.SourceTableRowCount, dbo.Audit_Table_Email.TargetTableName, dbo.Audit_Table_Email.TargetTableRowCount_Before, dbo.Audit_Table_Email.TargetTableRowCount_After, dbo.Audit_Table_Email.TGT_Difference, dbo.Audit_Table_Email.DI_PID, dbo.Audit_Table_Email.DI_CREATE_DATE FROM dbo.Audit_Table_Email WHERE dbo.Audit_Table_Email.DI_PID = '" + pid + "'"
Specify a data source aliasfalse
Data source alias""
Mappingid_MSSQL
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Encoding"ISO-8859-15"
Trim all the String/Char columnsfalse
Trim column[{SCHEMA_COLUMN=Audit_Table_ID, TRIM=false}, {SCHEMA_COLUMN=Job_PID, TRIM=false}, {SCHEMA_COLUMN=Run_Date, TRIM=false}, {SCHEMA_COLUMN=SourceTableName, TRIM=false}, {SCHEMA_COLUMN=SourceTableRowCount, TRIM=false}, {SCHEMA_COLUMN=TargetTableName, TRIM=false}, {SCHEMA_COLUMN=TargetTableRowCount_Before, TRIM=false}, {SCHEMA_COLUMN=TargetTableRowCount_After, TRIM=false}, {SCHEMA_COLUMN=TGT_Difference, TRIM=false}, {SCHEMA_COLUMN=DI_PID, TRIM=false}, {SCHEMA_COLUMN=DI_CREATE_DATE, TRIM=false}]
Label format__TABLE__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentReads the email audit table in preperation for sending the successful load email.
Use an existing validation rulefalse
Validation Rule Type

Schema for Audit_Table_Email :
ColumnKeyTypeLengthPrecisionNullableComment
Audit_Table_IDtrueint10false
Job_PIDfalseString255true
Run_Datefalsejava.util.Date233true
SourceTableNamefalseString255true
SourceTableRowCountfalseInteger10true
TargetTableNamefalseString255true
TargetTableRowCount_BeforefalseInteger10true
TargetTableRowCount_AfterfalseInteger10true
TGT_DifferencefalseInteger10true
DI_PIDfalseString255true
DI_CREATE_DATEfalsejava.util.Date233true

Original Function Parameters:
Component   tMSSqlOutput

      UNIQUE NAMEtDBOutput_1INPUT(S)tMap_1
LABELAudit_Table_Email_02OUTPUT(S)none

Component Parameters:
PropertiesValues
DatabasetMSSqlOutput
Unique NametDBOutput_1
Component NametMSSqlOutput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tMSSqlOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):DI_CNTL
Use an existing connectionfalse
Component List
JDBC ProviderMSSQL_PROP
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Database DriverMSSQL
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
Table"Audit_Table_Email"
Action on tableNONE
Turn on Identity insertfalse
Action on dataINSERT
Specify identity fieldfalse
Identity fieldJob_PID
Start value1
Step1
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Reject SchemaBuilt-In
Specify a data source aliasfalse
Data source alias""
Die on errortrue
Mappingid_MSSQL
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Encoding"ISO-8859-15"
Commit every10000
Additional columns[]
Use field optionsfalse
Field options[{SCHEMA_COLUMN=Job_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=Run_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SourceTableName, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SourceTableRowCount, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableName, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableRowCount_Before, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableRowCount_After, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Difference, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_CREATE_DATE, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}]
Ignore date out of rangefalse
Enable debug modefalse
Support null in "SQL WHERE" statementfalse
Use Batch Sizetrue
Batch Size10000
Label formatAudit_Table_Email_02
Hint format<b>_Audit_Table_Email_02_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentLoads the formated data to the email audit table for use later.
Use an existing validation rulefalse
Validation Rule Type

Schema for Audit_Table_Email :
ColumnKeyTypeLengthPrecisionNullableComment
Job_PIDfalseString255true
Run_Datefalsejava.util.Date233true
SourceTableNamefalseString255true
SourceTableRowCountfalseInteger10true
TargetTableNamefalseString255true
TargetTableRowCount_BeforefalseInteger10true
TargetTableRowCount_AfterfalseInteger10true
TGT_DifferencefalseInteger10true
DI_PIDfalseString255true
DI_CREATE_DATEfalsejava.util.Date233true

Original Function Parameters:
Component   tMSSqlOutput

      UNIQUE NAMEtDBOutput_2INPUT(S)tMap_4
LABELAudit_Table_Email_03OUTPUT(S)none

Component Parameters:
PropertiesValues
DatabasetMSSqlOutput
Unique NametDBOutput_2
Component NametMSSqlOutput
Version0.102 (ALPHA)
FamilyDatabases/DB Specifics/MS_SQL_Server
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tMSSqlOutput
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Property Typerepository: DB (MSSQL):DI_CNTL
Use an existing connectionfalse
Component List
JDBC ProviderMSSQL_PROP
Hostcontext.DI_CNTL_Server
Portcontext.DI_CNTL_Port
Schemacontext.DI_CNTL_Schema
Databasecontext.DI_CNTL_Database
Database DriverMSSQL
Usernamecontext.DI_CNTL_Login
Passwordcontext.DI_CNTL_Password
Table"Audit_Table_Email"
Action on tableNONE
Turn on Identity insertfalse
Action on dataINSERT
Specify identity fieldfalse
Identity fieldJob_PID
Start value1
Step1
REPOSITORY_ALLOW_AUTO_SWITCHtrue
SchemaBuilt-In
Reject SchemaBuilt-In
Specify a data source aliasfalse
Data source alias""
Die on errortrue
Mappingid_MSSQL
Additional JDBC Parameterscontext.DI_CNTL_AdditionalParams
Encoding"ISO-8859-15"
Commit every10000
Additional columns[]
Use field optionsfalse
Field options[{SCHEMA_COLUMN=Job_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=Run_Date, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SourceTableName, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=SourceTableRowCount, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableName, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableRowCount_Before, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TargetTableRowCount_After, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=TGT_Difference, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_PID, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}, {SCHEMA_COLUMN=DI_CREATE_DATE, UPDATE_KEY=false, DELETE_KEY=false, UPDATABLE=true, INSERTABLE=true}]
Ignore date out of rangefalse
Enable debug modefalse
Support null in "SQL WHERE" statementfalse
Use Batch Sizetrue
Batch Size10000
Label formatAudit_Table_Email_03
Hint format<b>_Audit_Table_Email_03_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentLoads the formated data to the email audit table for use later.
Use an existing validation rulefalse
Validation Rule Type

Schema for Audit_Table_Email :
ColumnKeyTypeLengthPrecisionNullableComment
Job_PIDfalseString255true
Run_Datefalsejava.util.Date233true
SourceTableNamefalseString255true
SourceTableRowCountfalseInteger10true
TargetTableNamefalseString255true
TargetTableRowCount_BeforefalseInteger10true
TargetTableRowCount_AfterfalseInteger10true
TGT_DifferencefalseInteger10true
DI_PIDfalseString255true
DI_CREATE_DATEfalsejava.util.Date233true

Original Function Parameters:
Component   tFlowToIterate

      UNIQUE NAMEtFlowToIterate_1INPUT(S)tDBInput_1
LABELFlow_To_IterateOUTPUT(S)tJavaFlex_1

Component Parameters:
PropertiesValues
Unique NametFlowToIterate_1
Component NametFlowToIterate
Version0.101 (ALPHA)
FamilyOrchestration
Startablefalse
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tFlowToIterate
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Use the default (key, value) in global variables.true
Customize[]
SchemaBuilt-In
Label formatFlow_To_Iterate
Hint format<b>_Flow_To_Iterate_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentPasses each record as it's read to the create email body.
Use an existing validation rulefalse
Validation Rule Type

Schema for tFlowToIterate_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJavaFlex

      UNIQUE NAMEtJavaFlex_1INPUT(S)tFlowToIterate_1
LABELCreate_Email_BodyOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametJavaFlex_1
Component NametJavaFlex
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTfalse
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticsfalse
Helporg.talend.help.tJavaFlex
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
Data Auto Propagatetrue
Start code// start part of your Java code //String message = "Fiscal Years processed " + context.FY_Start + " to " + context.FY_End + "\n";
Main code// here is the main part of the component, // a piece of code executed in the row // loop String message = "\nTable: " + ((String) globalMap.get("email_details.TargetTableName")) + " has been populated successfully for fiscal years " + context.FY_Start + " thru " + context.FY_End + ". Records before: " + String.valueOf((Integer)globalMap.get("email_details.TargetTableRowCount_Before")) + " " + "Records after: " + String.valueOf((Integer)globalMap.get("email_details.TargetTableRowCount_After")) + " " + "Difference : " + String.valueOf((Integer)globalMap.get("email_details.TGT_Difference")); context.setProperty("vEmailMessage", context.getProperty("vEmailMessage") + "\n" + message);
End code// end of the component, outside/closing the loop
TOS2.0false
TOS3.2false
TOS4.0true
Import//import java.util.List;
Label formatCreate_Email_Body
Hint format<b>_Create_Email_Body_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentLoops through each records generating the email text and inserting it into the email message body.
Use an existing validation rulefalse
Validation Rule Type

Schema for tJavaFlex_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_1INPUT(S)none
LABELClear_FN_Job_ContextsOUTPUT(S)tJava_2

Component Parameters:
PropertiesValues
Unique NametJava_1
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_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tJava

      UNIQUE NAMEtJava_2INPUT(S)tJava_1
LABELSet_FN_Job_Contexts_For_Job_StepOUTPUT(S)tRunJob_3

Component Parameters:
PropertiesValues
Unique NametJava_2
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("Variables from 01"); //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
CommentSets step specific contexts (not applicable to this step at this time).
Use an existing validation rulefalse
Validation Rule Type

Schema for tJava_2 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tRunJob

      UNIQUE NAMEtRunJob_1INPUT(S)tRunJob_3
LABEL__PROCESS__OUTPUT(S)tMap_4,  tSetGlobalVar_1

Component Parameters:
PropertiesValues
Unique NametRunJob_1
Component NametRunJob
Version0.101 (ALPHA)
FamilySystem|Orchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
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
JobFNS03_UM_GLQ_ACCTA
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 format__PROCESS__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentFN_GLQ_ACCTA load step
Use an existing validation rulefalse
Validation Rule Type

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

Original Function Parameters:
Component   tRunJob

      UNIQUE NAMEtRunJob_3INPUT(S)tJava_2
LABEL__PROCESS__OUTPUT(S)tMap_1,  tRunJob_1

Component Parameters:
PropertiesValues
Unique NametRunJob_3
Component NametRunJob
Version0.101 (ALPHA)
FamilySystem|Orchestration
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWfalse
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
JobFNS02_UM_GLQ_REPRTING
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 format__PROCESS__
Hint format<b>__UNIQUE_NAME__</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentFN_GLQ_REPRTING load step.
Use an existing validation rulefalse
Validation Rule Type

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

Original Function Parameters:
Component   tSendMail

      UNIQUE NAMEtSendMail_1INPUT(S)tDBInput_1
LABELSend_Email_notifyOUTPUT(S)none

Component Parameters:
PropertiesValues
Unique NametSendMail_1
Component NametSendMail
Version0.101 (ALPHA)
FamilyInternet
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tSendMail
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Tocontext.tsendMailToSuccess
Fromcontext.tsendMailFrom
Show sender's name?true
Sendernamecontext.tsendMailUsername
Cc
Bcc
Subject"Staging Build Results for " + context.FNContext_ServiceName + " for " + TalendDate.formatDate("yyyy-MM-dd HH:mm:ss", TalendDate.getCurrentDate())
Message"\nFiscal Years processed " + context.FY_Start + " to " + context.FY_End + "\n" + StringHandling.RIGHT(context.getProperty("vEmailMessage"),StringHandling.LEN(context.getProperty("vEmailMessage")) - 5) + "\n" + "\nThank you," + "\nThe DARTS Team"
Die if the attachment file doesn't exist.false
Attachments[]
Other headers[]
SMTP hostcontext.tsendMailSMTPHost
SMTP portcontext.tsendMailSMTPPort
SSL Supporttrue
STARTTLS Supportfalse
ImportanceNormal
Need authentication?false
Usernamecontext.tsendMailUsername
Password**************
Die on errortrue
MIME subtype from the 'text' MIME typeplain
charset used for encoding message"UTF-8"
Set localhostfalse
Localhost"localhost"
SchemaBuilt-In
Label formatSend_Email_notify
Hint format<b>_Send_Email_notify_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentSends the successful email message.
Use an existing validation rulefalse
Validation Rule Type

Schema for out_GlobalVar :
ColumnKeyTypeLengthPrecisionNullableComment
pidfalseString20true
root_pidfalseString20true
jobfalseString255true
projectfalseString50true
originfalseString255true
messagefalseString255true
codefalseInteger3true
Warning_CodefalseInteger10true
Warning_MessagefalseString255true
Warning_PriorityfalseInteger10true
Error_MessagefalseString255true
Origin_for_ErrorfalseString255true

Original Function Parameters:
Component   tSetGlobalVar

      UNIQUE NAMEtSetGlobalVar_1INPUT(S)tRunJob_1
LABELSet_GVarOUTPUT(S)tDBInput_1

Component Parameters:
PropertiesValues
Unique NametSetGlobalVar_1
Component NametSetGlobalVar
Version0.101 (ALPHA)
FamilyCustom_Code
Startfalse
Startabletrue
SUBTREE_STARTtrue
END_OF_FLOWtrue
Activatetrue
DUMMYfalse
tStatCatcher Statisticstrue
Helporg.talend.help.tSetGlobalVar
Update componentstrue
IREPORT_PATH
JAVA_LIBRARY_PATHE:\Talend\TOS_DI-Win32-20181026_1147-V7.1.1\configuration\lib\java
Subjob color
Title color
Variables[{KEY="vEmailMessage", VALUE="START_MESSAGE"}]
SchemaBuilt-In
Label formatSet_GVar
Hint format<b>_Set_GVar_</b><br>__COMMENT__
Connection formatrow
Show Informationfalse
CommentSets the "vEmailMessage" global variable.
Use an existing validation rulefalse
Validation Rule Type

Schema for tSetGlobalVar_1 :
ColumnKeyTypeLengthPrecisionNullableComment

Original Function Parameters:
Component   tMap

      UNIQUE NAMEtMap_1INPUT(S)tRunJob_3
LABELBuffered_Data_02OUTPUT(S)tDBOutput_1



Component Parameters:
PropertiesValues
tStatCatcher Statistics
false
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
true
Show Information
false
Comment
Captures buffered data returned from FNS02_UM_GLQ_REPRTING step, formats it, and passes it to the audit table load.
Use an existing validation rule
false

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

Metadata Table Entries(
								row2
								):
							
NameTypeExpressionisNullable
Job_PIDStringtrue
Run_Datejava.util.Datetrue
TargetTableRowCount_BeforeIntegertrue
TargetTableRowCount_AfterIntegertrue
SourceTableNameStringtrue
TargetTableNameStringtrue
SourceTableRowCountIntegertrue

Constraint Table Entries(
								row2
								):
							
NameTypeExpressionisNullable

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

Metadata Table Entries(
								job_stats
								):
							
NameTypeExpressionisNullable
Job_PIDStringrow2.Job_PIDtrue
Run_Datejava.util.Daterow2.Run_Datetrue
SourceTableNameStringrow2.SourceTableNametrue
SourceTableRowCountIntegerrow2.SourceTableRowCounttrue
TargetTableNameStringrow2.TargetTableNametrue
TargetTableRowCount_BeforeIntegerrow2.TargetTableRowCount_Beforetrue
TargetTableRowCount_AfterIntegerrow2.TargetTableRowCount_Aftertrue
TGT_DifferenceIntegerrow2.TargetTableRowCount_After - row2.TargetTableRowCount_Beforetrue
DI_PIDStringpidtrue
DI_CREATE_DATEjava.util.DateTalendDate.getCurrentDate()true

Constraint Table Entries(
								job_stats
								):
							
NameTypeExpressionisNullable

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

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Component  									tMap

								     							UNIQUE NAMEtMap_4INPUT(S)tRunJob_1
LABELBuffered_Data_03OUTPUT(S)tDBOutput_2



Component Parameters:
PropertiesValues
tStatCatcher Statistics
true
Mapping links display as:
AUTO
Temp data directory path:
Max buffer size (nb of rows):
2000000
Ignore trailing zeros for BigDecimal
true
Show Information
false
Comment
Captures buffered data returned from FNS03_UM_GLQ_ACCTA step, formats it, and passes it to the audit table load.
Use an existing validation rule
false

Mapper table for tMap_4
				(
				input
				):
			
Mapper table Properties(
								row3
								):
							
PropertiesValues
Namerow3
Matching-modeUNIQUE_MATCH
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								row3
								):
							
NameTypeExpressionisNullable
Job_PIDStringtrue
Run_Datejava.util.Datetrue
TargetTableRowCount_BeforeIntegertrue
TargetTableRowCount_AfterIntegertrue
SourceTableNameStringtrue
TargetTableNameStringtrue
SourceTableRowCountIntegertrue

Constraint Table Entries(
								row3
								):
							
NameTypeExpressionisNullable

Mapper table for tMap_4
				(
				output
				):
			
Mapper table Properties(
								job_stats2
								):
							
PropertiesValues
Namejob_stats2
Matching-mode
isMinimizedfalse
isRejectfalse
isRejectInnerJoinfalse
isInnerJoinfalse
expressionFilternull

Metadata Table Entries(
								job_stats2
								):
							
NameTypeExpressionisNullable
Job_PIDStringrow3.Job_PIDtrue
Run_Datejava.util.Daterow3.Run_Datetrue
SourceTableNameStringrow3.SourceTableNametrue
SourceTableRowCountIntegerrow3.SourceTableRowCounttrue
TargetTableNameStringrow3.TargetTableNametrue
TargetTableRowCount_BeforeIntegerrow3.TargetTableRowCount_Beforetrue
TargetTableRowCount_AfterIntegerrow3.TargetTableRowCount_Aftertrue
TGT_DifferenceIntegerrow3.TargetTableRowCount_After - row3.TargetTableRowCount_Beforetrue
DI_PIDStringpidtrue
DI_CREATE_DATEjava.util.DateTalendDate.getCurrentDate()true

Constraint Table Entries(
								job_stats2
								):
							
NameTypeExpressionisNullable

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

Metadata Table Entries(
								Var
								):
							
NameTypeExpressionisNullable

Constraint Table Entries(
								Var
								):
							
NameTypeExpressionisNullable