One Star

How to match date format fields and update records in the entire schema of database?

Hi All,

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. 

 

thanks,

Rajeev Kumar

2 REPLIES
Moderator

Re: How to match date format fields and update records in the entire schema of database?

Hello,

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?

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
One Star

Re: How to match date format fields and update records in the entire schema of database?

Sabrina,
We have requirement to age the Data of entire table of database.To do
same,we have to increase the daytime column to 10 or 20 days . We want to
achieve this by using regex scipt which could help us automatically look
into enter datebase and update data accordingly in all tables.


Let me know if this can be done by Using talend transformation.

Thanks
Rajeev Kumar