How to delta load according to Salesforce's LastModifiedDate into an RDS?
I've got the input Salesforce and output RDS connection so far. My database has a column for storing LastModifiedDate from Salesforce. But I don't know where to configure a check for running the job only if LastModifiedDate stored in the database is less than the current Date of running the job. I am very new to Talend, could you please answer with screenshots? There are similar questions but I didn't find them comprehensive enough for a newbie.
By definition, LastModifiedDate for existing records is always less than the current date as it cannot be set in the future.
If you know the Datetime to use as a criteria, you must have it as a global or context variable to be used in the tSalesforceInput component for the Query condition.
If you want to get records modified during the last day (or week, or month, ...), use a Salesforce date literal line this: "LastModifiedDate >= LAST_N_DAYS:1"
