We are trying to migrate PL/SQL scripts to Talend ETL process.
So just want to Know if the following functions are available in Talend so that we can go forward.
--SUBSTR
--INSTR
--DENSE RANK
--LAG Function in Oracle
--SYSTIMESTAMP
--Some date handling functions like TRUNC date to hourly level
--Partition by
Please let me know the user-defined logic if the build-in functions are not available.
You can do all of this in Talend.
Talend provides routines for things such as TalendDate.getCurrentDate; but remember that this is just Java. You can also write your own routines.
Talend also has TalendString & StringHandling routines. As strings in Talend are just Java String, you can use all of the String methods e.g. for sub-stringing.
There are components that will help with some of your other requirements.
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.
I'd get familiar with Talend first, before 'translating' PL/SQL as it does require a different mindset.
