topic Re: Dynamic query in Talend Studio

Dynamic query

Anonymous — Wed, 10 Jun 2020 06:05:38 GMT

Hi Team,

I am trying to write a query which run everyday at morning.

like "Select * from Table_name where date =last_time_batch end_date_time"

here i need the date and time when it last time ran successfully.

example: batch run time: 10/06/10 4.00 am and it ran till 4.23am. then my batch end date is 10/06/10 4.23am

note : i don't have to store date in DB.

please guide me .

Thanks,

Teja

Re: Dynamic query

manodwhb — Wed, 10 Jun 2020 06:10:27 GMT

@Tejeswar2020 , you need to maintain a table or a file to read the date which you stored in the previous run.

Re: Dynamic query

Anonymous — Wed, 10 Jun 2020 07:11:36 GMT

Thanks for your reply @manodwhb .

yes i can manage a file . i know how to take value from a file using tcontext but how can i update again same file with latest date.

Thanks,

Teja

Re: Dynamic query

manodwhb — Wed, 10 Jun 2020 07:21:39 GMT

@Tejeswar2020 , if you do not select append check box it will always override last file with new file.

Re: Dynamic query

Anonymous — Wed, 10 Jun 2020 07:49:49 GMT

yeah @manodwhb i am not appending but once contextload is success then i am trying to update the file but its not updating. in tmap i am modifing dates. i have attached the screenshot. please help me.

input file contains: date;20200610

Thanks,

Teja

Re: Dynamic query

manodwhb — Wed, 10 Jun 2020 08:15:39 GMT

@Tejeswar2020 , you were not getting any rows from tfileinputdelimitted_2,with out any rows how will it populate the data to outputfile?