Incremental mode in Talend
I have 2 tables in my database-: Office -
and office_import :
The office table is fed by office_import table using incremental mode based on the office_name.
The field END_date of Office table is currently NULL, but I need to check in the office_name from office table does not exist in the office_import table, then the END_date needs to be updated with the current date, otherwise it shall remain NULL only.
I have created the job as below but the job keeps on executing for more than 3 hours and then I gets the I/O Timeout error. 
I have used the below script to feed the END_Date -
Please help.
In tMap , you don't have any join key between tables row2 and row3 : you just have a cross join. Drag&drop "Office_name" from row2 onto row3.Import_office_name in order to get a proper left join. (you'll see the purple link between the two tables, indicating the join)
- NullPointerException in Java JDK code while performing parallelStream.forEach(..)
- Locating code that is filling PermGen with dead Groovy code
- Cannot find test class in project - "The input type of the launch configuration does not exist"
- Passing the values to the fraction class in java
- How to use different authentication methods for different paths using Spring Security
- how to fetch and validate csv header in open csv?
- 4-Sum algorithm failing with duplicate values in Java
- Error getting month while using Calendar object
- java Calendar Timezones strange stuff
- java.util.Date class with different approach for same date gives different output
- Finding out the type of invoked method in JDT
- How to get the size of a file in MB (Megabytes)?
- Exception in thread "main" java.lang.IllegalStateException: Attempted to load Config resource 'class path resource [application.yml]'
- Why does Google Calendar.Events.Watch say my request is not HTTPS
- Java - Class.forName, how to get a Field from Class
- Use of verify() method with and without times(1) parameter
- JDBC connection without database definition
- Running my testNG project from a jar using Maven
- Do subclasses inherit interfaces?
- Spring Security - how can I ask invoke access control methods directly?
- most accurate time type in java?
- How to get the currently selected application from Windows in Java
- validate the credit card expiry date using java?
- Finding the square root of a number by using binary search
- log4j : current time in milliseconds
- Why Joda DateTime gives different result than Java Date?
- Tomcat - maxThreads vs. maxConnections
- Android notification importance cannot be changed
- How to enable all endpoints in actuator (Spring Boot 2.0.0 RC1)
- Map rainbow colors to RGB