0_ETL_gesamt / - 2024/08/14 17:49:18.129 - 2024/08/14 18:22:57.940 GC_DWH 192.168.2.43 MSSQL Native GC_DWH 1433 sa Encrypted 2be98afc86aa7f2a9ad1fbb238ec3fe99 EXTRA_OPTION_MSSQL.instance GLOBALCUBE FORCE_IDENTIFIERS_TO_LOWERCASE N FORCE_IDENTIFIERS_TO_UPPERCASE N IS_CLUSTERED N MSSQL_DOUBLE_DECIMAL_SEPARATOR N PORT_NUMBER 1433 PRESERVE_RESERVED_WORD_CASE Y QUOTE_ALL_FIELDS N SUPPORTS_BOOLEAN_DATA_TYPE Y SUPPORTS_TIMESTAMP_DATA_TYPE Y USE_POOLING N ID_JOB Y ID_JOB CHANNEL_ID Y CHANNEL_ID JOBNAME Y JOBNAME 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 START_JOB_ENTRY N START_JOB_ENTRY CLIENT N CLIENT ID_BATCH Y ID_BATCH CHANNEL_ID Y CHANNEL_ID LOG_DATE Y LOG_DATE JOBNAME Y TRANSNAME JOBENTRYNAME Y STEPNAME 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 RESULT Y RESULT NR_RESULT_ROWS Y NR_RESULT_ROWS NR_RESULT_FILES Y NR_RESULT_FILES LOG_FIELD N LOG_FIELD COPY_NR N COPY_NR 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 N Start SPECIAL Y N N 0 0 60 12 0 1 1 N Y 0 80 64 OPTIMA? SIMPLE_EVAL variable OPTIMA boolean equal equal true N N Y 0 80 256 ETL_OPTIMA JOB rep_name \ETL_OPTIMA N N N N N N Nothing Y N N N N Pentaho local Y N N Y 0 80 384 Set variables SET_VARIABLES Y C:\Projekte\Pentaho\default.conf JVM OPTIMA true JVM LOCOSOFT false JVM N Y 0 208 64 4_GC_CONFIG_dwh JOB rep_name \4_GC_CONFIG_dwh\4_GC_CONFIG_dwh N N N N N N Nothing Y N N N N Pentaho local Y N N Y 0 352 576 Truncate tables GC_DWH TRUNCATE_TABLES GC_DWH N Verkauf dbo Fahrzeug dbo Kunde dbo Verkaeufer dbo N Y 0 352 64 alles erledigt? SPECIAL N Y N 0 0 60 12 0 1 1 N Y 0 352 464 LOCOSOFT? SIMPLE_EVAL variable LOCOSOFT boolean equal equal true N N Y 0 192 256 ETL_LOCOSOFT JOB rep_name \ETL_OPTIMA N N N N N N Nothing Y N N N N Pentaho local Y N N Y 0 192 384 parallel SPECIAL N Y N 0 0 60 12 0 1 1 N Y 0 352 160 OPTIMA? ETL_OPTIMA 0 0 Y Y N Start Set variables 0 0 Y Y Y Set variables Truncate tables GC_DWH 0 0 Y Y N ETL_OPTIMA alles erledigt? 0 0 Y Y N alles erledigt? 4_GC_CONFIG_dwh 0 0 Y Y Y LOCOSOFT? ETL_LOCOSOFT 0 0 Y Y N ETL_LOCOSOFT alles erledigt? 0 0 Y Y N Truncate tables GC_DWH parallel 0 0 Y Y N parallel OPTIMA? 0 0 Y Y Y parallel LOCOSOFT? 0 0 Y Y Y