JVM arguments: Massively parallel talend processes
-Xms8g -Xmx100g -XX:+UseParallelGC -XX:+UseAdaptiveSizePolicy -XX:GCTimeRatio=19 -XX:MinHeapFreeRatio=20 -XX:InitiatingHeapOccupancyPercent=10
Tag: Talend
Talend display DB rejects
In a tJavaRow component: System.out.println(input_row.columnName + ” ” + input_row.errorMessage);
Snowflake Local Timezone
To record timestamps in local timezone format nicely in via Talend use datatype: TIMESTAMPLTZ(3) To display without the offset value set session variable: ALTER SESSION SET TIMESTAMP_LTZ_OUTPUT_FORMAT = ‘YYYY-MM-DD HH24:MI:SS.FF3’