kindly suggest i am having a column where my input looks like 7-Jan but i need output as 7/1/2019(current year),how can i achieve this.
Please try like this :
select to_char(to_date('07-Jan' || '-' || extract(year from sysdate),'DD-MON-YYYY'),'DD/MM/YYYY') from dual ;
@muralam,i will suggest you to create a new filed in tmap by using var as a sting with -2019 and concatenate the source field with variable field and then convert to sting to data.
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.