I have a scenario that I need to download and process a full file load to the database and get the latest file monthly which is the date is 18th. And if ever that I need to process a full file for Novemeber 12 I need to get the October 18th file since there's no November 18 data yet. How can I determine that using MySQL Query on tMySQLInput?
SELECT DATE_FORMAT(MAX(log_date) ,'%b%d-*') ftp_full from TBL_NAMEwhere DAY(log_date)>= 16 ;
2. The file name on the database is like this: FNameMonthDay-(incremental number from the source).
I already determine on how can I get the MonthDay which is the abbreviated month and day is like this: FNameApr18
But, I don't know how can I make the incremental number after -, the data is like: FNameApr18-111 the Next month it will be FnameMay18-112, but I don't know how can I do that on talend.
Below is my component screenshot.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema