We have requirement to age old data of entire schema(14000 tables) to 100 days. How to do the date pattern matching and update the date of 14000 tables.
There is a built-in function TalendDate.compareDate in talend. If you want to match date with a default date, you can join the both objects (main column and lookup column) in tMap.
Would you mind elaborating your case with an example with input and expected output values?
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.