compare two date and load results in database

Anonymous — Mon, 28 Oct 2019 13:07:45 GMT

hello ,

I am beginner in talend and i need help

i have building a job wich load results in database with result of comparaison of two date

in my first component tparam , we have the result of the last update date and in the W-CLIENT

we have the update date of any enregistrement in the database

we should have the the enregistrement in the database which the update date >= Tparam date

incremental loading

there is a screenshot which describe the job

Re: compare two date and load results in database

Anonymous — Mon, 28 Oct 2019 14:17:59 GMT

It looks like you are trying to prepare a SQL query which is used to return data based on a date comparison. If that is the case, you need to think about the following. Dates are not necessarily converted and formatted as Strings in the correct format for a SQL query. So you will need to use the routines.TalendDate methods to format your date in the correct format to be used in your query. The next thing to think about is that you will need to test this query. The best thing to do here is to test your query using a query analyser tool. I see you are printing your Query to the output, so I assume this is what you are trying.

topic compare two date and load results in database in Talend Studio

compare two date and load results in database

Re: compare two date and load results in database