https://community.qlik.com/t5/Talend-Studio/Migration-from-PL-SQL-to-Talend/m-p/2342466#M110329 You can do all of this in Talend. <BR />Talend provides routines for things such as TalendDate.getCurrentDate; but remember that this is just Java. You can also write your own routines. <BR />Talend also has TalendString &amp; StringHandling routines. As strings in Talend are just Java String, you can use all of the String methods e.g. for sub-stringing. <BR />There are components that will help with some of your other requirements. <BR />If you're still reading/writing Oracle, then you will want to consider what you may still want to push down to the database. In some cases you may want to push some joins down; but never business logic. <BR />I'd get familiar with Talend first, before 'translating' PL/SQL as it does require a different mindset. Sat, 14 Sep 2013 08:52:14 GMT Anonymous 2013-09-14T08:52:14Z https://community.qlik.com/t5/Talend-Studio/Migration-from-PL-SQL-to-Talend/m-p/2342465#M110328 We are trying to migrate PL/SQL scripts to Talend ETL process. <BR />So just want to Know if the following functions are available in Talend so that we can go forward. <BR />--SUBSTR <BR />--INSTR <BR />--DENSE RANK <BR />--LAG Function in Oracle <BR />--SYSTIMESTAMP <BR />--Some date handling functions like TRUNC date to hourly level <BR />--Partition by <BR />Please let me know the user-defined logic if the build-in functions are not available. <BR /> <BR />Thanks, <BR />Ajay Fri, 13 Sep 2013 18:18:51 GMT https://community.qlik.com/t5/Talend-Studio/Migration-from-PL-SQL-to-Talend/m-p/2342465#M110328 Anonymous 2013-09-13T18:18:51Z https://community.qlik.com/t5/Talend-Studio/Migration-from-PL-SQL-to-Talend/m-p/2342466#M110329 You can do all of this in Talend. <BR />Talend provides routines for things such as TalendDate.getCurrentDate; but remember that this is just Java. You can also write your own routines. <BR />Talend also has TalendString &amp; StringHandling routines. As strings in Talend are just Java String, you can use all of the String methods e.g. for sub-stringing. <BR />There are components that will help with some of your other requirements. <BR />If you're still reading/writing Oracle, then you will want to consider what you may still want to push down to the database. In some cases you may want to push some joins down; but never business logic. <BR />I'd get familiar with Talend first, before 'translating' PL/SQL as it does require a different mindset. Sat, 14 Sep 2013 08:52:14 GMT https://community.qlik.com/t5/Talend-Studio/Migration-from-PL-SQL-to-Talend/m-p/2342466#M110329 Anonymous 2013-09-14T08:52:14Z