Load_entity_dimensions Normal 0 / ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID TRANSNAME Y TRANSNAME STATUS Y STATUS LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS STARTDATE Y STARTDATE ENDDATE Y ENDDATE LOGDATE Y LOGDATE DEPDATE Y DEPDATE REPLAYDATE Y REPLAYDATE LOG_FIELD Y LOG_FIELD EXECUTING_SERVER N EXECUTING_SERVER EXECUTING_USER N EXECUTING_USER CLIENT N CLIENT ID_BATCH Y ID_BATCH SEQ_NR Y SEQ_NR LOGDATE Y LOGDATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS INPUT_BUFFER_ROWS Y INPUT_BUFFER_ROWS OUTPUT_BUFFER_ROWS Y OUTPUT_BUFFER_ROWS ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE LOGGING_OBJECT_TYPE Y LOGGING_OBJECT_TYPE OBJECT_NAME Y OBJECT_NAME OBJECT_COPY Y OBJECT_COPY REPOSITORY_DIRECTORY Y REPOSITORY_DIRECTORY FILENAME Y FILENAME OBJECT_ID Y OBJECT_ID OBJECT_REVISION Y OBJECT_REVISION PARENT_CHANNEL_ID Y PARENT_CHANNEL_ID ROOT_CHANNEL_ID Y ROOT_CHANNEL_ID ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE TRANSNAME Y TRANSNAME STEPNAME Y STEPNAME STEP_COPY Y STEP_COPY LINES_READ Y LINES_READ LINES_WRITTEN Y LINES_WRITTEN LINES_UPDATED Y LINES_UPDATED LINES_INPUT Y LINES_INPUT LINES_OUTPUT Y LINES_OUTPUT LINES_REJECTED Y LINES_REJECTED ERRORS Y ERRORS LOG_FIELD N LOG_FIELD ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE METRICS_DATE Y METRICS_DATE METRICS_CODE Y METRICS_CODE METRICS_DESCRIPTION Y METRICS_DESCRIPTION METRICS_SUBJECT Y METRICS_SUBJECT METRICS_TYPE Y METRICS_TYPE METRICS_VALUE Y METRICS_VALUE 0.0 0.0 10000 50 50 N Y 50000 Y N 1000 100 - 2023/06/12 18:02:38.343 - 2023/06/12 18:02:38.343 H4sIAAAAAAAAAAMAAAAAAAAAAAA= N dwh 10.211.55.15 MYSQL Native dwh 3306 juanlf Encrypted 2be98afc86aa7f2e4cb79bc71da9bff89 FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER 3306 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N STREAM_RESULTS Y SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N stage SQLITE Native /Volumes/T7 Touch/TFG/Stage/stage.db -1 Encrypted FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N PORT_NUMBER -1 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N unique_company Get_id_company Y unique_priority Get_id_priority Y Get_id_priority id_priority_null Y id_priority_null d_priority Y Get_id_company id_company_null Y id_company_null d_company Y Priority priority_not_null Y priority_not_null unique_priority Y Company company_not_null Y company_not_null unique_company Y Group group_not_null Y group_not_null unique_group Y unique_group Get_id_assigned_group Y Get_id_assigned_group id_assigned_group_null Y id_assigned_group_null d_assigned_group Y login login_not_null Y login_not_null unique_login Y unique_login Get_id_login Y Get_id_login id_login_null Y id_login_null d_login Y Table input Priority Y Table input Group Y Table input login Y Table input Company Y Company SelectValues Y 1 none Company Company_desc N

256 96 Y Get_id_assigned_group DBLookup Y 1 none dwh Y N 0 dwh d_assigned_group N N Assigned_Group assigned_group = id_assigned_group id_assigned_group Integer

656 176 Y Get_id_company DBLookup Y 1 none dwh Y N 0 dwh d_company N N Company Company = id_company id_company Integer

656 96 Y Get_id_login DBLookup Y 1 none dwh Y N 0 dwh d_login N N Login login = id_login id_login Integer

656 256 Y Get_id_priority DBLookup Y 1 none dwh Y N 0 dwh d_priority N N Priority_ID id_priority = id_priority id_priority Integer

656 32 Y Group SelectValues Y 1 none Assigned_Group N

256 176 Y Priority SelectValues Y 1 none Priority_ID Priority_Desc Response_desc Resolution_desc N

256 32 Y Table input TableInput N 1 none stage SELECT Audit_date , n_ID , ID , Priority_ID , Priority_Desc , Assigned_Group , New_assign , Login , Assignee , Company , Company_desc , Resolved_date , total_RD , l_seconds , Response_desc , Resolution_desc , SLA_response , SLA_response_meet , SLA_response_date , SLA_response_group , SLA_response_login , SLA_resolution , SLA_resolution_meet , SLA_resolution_date , SLA_resolution_group , SLA_resolution_login , SLA_reopen , SLA_reopen_meet , SLA_reopen_group , SLA_reopen_login , SLA_reopen_date , t_first_resolution , t_total_resolution , t_pending FROM incidents ORDER BY ID, Audit_date; 0 N N N N Date normal Audit_date -1 -1 Table input Audit_date , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal n_ID 9 0 Table input n_ID ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N String normal ID 2147483647 -1 Table input ID , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal Priority_ID 9 0 Table input Priority_ID ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N String normal Priority_Desc 2147483647 -1 Table input Priority_Desc , . none N Y 0 N N N en_US Atlantic/Canary N String normal Assigned_Group 2147483647 -1 Table input Assigned_Group , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal New_assign 9 0 Table input New_assign ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N String normal Login 2147483647 -1 Table input Login , . none N Y 0 N N N en_US Atlantic/Canary N String normal Assignee 2147483647 -1 Table input Assignee , . none N Y 0 N N N en_US Atlantic/Canary N String normal Company 2147483647 -1 Table input Company , . none N Y 0 N N N en_US Atlantic/Canary N String normal Company_desc 2147483647 -1 Table input Company_desc , . none N Y 0 N N N en_US Atlantic/Canary N Date normal Resolved_date -1 -1 Table input Resolved_date , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal total_RD 9 0 Table input total_RD ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal l_seconds 9 0 Table input l_seconds ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N String normal Response_desc 2147483647 -1 Table input Response_desc , . none N Y 0 N N N en_US Atlantic/Canary N String normal Resolution_desc 2147483647 -1 Table input Resolution_desc , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_response 2147483647 -1 Table input SLA_response , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal SLA_response_meet 9 0 Table input SLA_response_meet ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N Date normal SLA_response_date -1 -1 Table input SLA_response_date , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_response_group 2147483647 -1 Table input SLA_response_group , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_response_login 2147483647 -1 Table input SLA_response_login , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_resolution 2147483647 -1 Table input SLA_resolution , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal SLA_resolution_meet 9 0 Table input SLA_resolution_meet ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N Date normal SLA_resolution_date -1 -1 Table input SLA_resolution_date , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_resolution_group 2147483647 -1 Table input SLA_resolution_group , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_resolution_login 2147483647 -1 Table input SLA_resolution_login , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_reopen 2147483647 -1 Table input SLA_reopen , . none N Y 0 N N N en_US Atlantic/Canary N Integer normal SLA_reopen_meet 9 0 Table input SLA_reopen_meet ####0;-####0 , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_reopen_group 2147483647 -1 Table input SLA_reopen_group , . none N Y 0 N N N en_US Atlantic/Canary N String normal SLA_reopen_login 2147483647 -1 Table input SLA_reopen_login , . none N Y 0 N N N en_US Atlantic/Canary N Date normal SLA_reopen_date -1 -1 Table input SLA_reopen_date , . none N Y 0 N N N en_US Atlantic/Canary N Number normal t_first_resolution 0 0 Table input t_first_resolution ####0.0#########;-####0.0######### , . none N Y 0 N N N en_US Atlantic/Canary N Number normal t_total_resolution 0 0 Table input t_total_resolution ####0.0#########;-####0.0######### , . none N Y 0 N N N en_US Atlantic/Canary N Number normal t_pending 0 0 Table input t_pending ####0.0#########;-####0.0######### , . none N Y 0 N N N en_US Atlantic/Canary N

96 128 Y company_not_null FilterRows Y 1 none unique_company N Company IS NOT NULL

384 96 Y d_assigned_group TableOutput Y 1 none dwh dwh d_assigned_group 1000 N N Y Y N N Y N Y N Assigned_Group Assigned_Group

928 176 Y d_company TableOutput Y 1 none dwh dwh d_company 1000 N N Y Y N N Y N Y N Company Company Company_desc Company_desc

928 96 Y d_login TableOutput Y 1 none dwh dwh d_login 1000 N N Y Y N N Y N Y N Login Login Assignee Assignee

928 256 Y d_priority TableOutput Y 1 none dwh dwh d_priority 1000 N N Y Y N N Y N Y N id_priority Priority_ID Priority_Desc Priority_Desc response_desc Response_desc resolution_desc Resolution_desc

928 32 Y group_not_null FilterRows Y 1 none unique_group N Assigned_Group IS NOT NULL

384 176 Y id_assigned_group_null FilterRows Y 1 none d_assigned_group N id_assigned_group IS NULL

800 176 Y id_company_null FilterRows Y 1 none d_company N id_company IS NULL

800 96 Y id_login_null FilterRows Y 1 none d_login N id_login IS NULL

800 256 Y id_priority_null FilterRows Y 1 none d_priority N id_priority IS NULL

800 32 Y login SelectValues Y 1 none Login Assignee N

256 256 Y login_not_null FilterRows Y 1 none unique_login N Login IS NOT NULL

384 256 Y priority_not_null FilterRows Y 1 none unique_priority N Priority_ID IS NOT NULL

384 32 Y unique_company SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y Company Y N N 0 N

528 96 Y unique_group SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y Assigned_Group Y N N 0 N

528 176 Y unique_login SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y Login Y N N 0 N

528 256 Y unique_priority SortRows Y 1 none %%java.io.tmpdir%% out 1000000 N Y Priority_ID Y N N 0 N

528 32 Y N