Comparing with String values always use like below.
"Umesh".equals(row1.UserName) or "Umesh".equalsIgnoreCase(row1.UserName) instead of "Umesh"=row1.UserName or row1.UserName.equalsIgnoreCase("Umesh")
Avoid using Short hand method or class methods for string.
Use StringHandling.TRIM(string); //for Trim
Use String.valueOf(SomeObject) instead .toString()
Use TalendDate.isDate("yyyy-MM-dd", "2015-02-19")for date validation
Use Relational.ISNULL(null) function to check whether string is null or not.
Exclude unwanted routines from build.
Remove or add required routines to the job, because unnecessarily it will be exported with job. you can manage routines by following below steps.
Right Click on job from Repository.
Select Option “Setup routine dependencies”.
Now you will have new window with two tabs one for “user routines” and other one for ” System routines” by using [+] or remove button on each tab you can manage routines.
see the Image for more details.
Disable “Check for extra features ” during Talend startup.
The step: “Check for Extra features to be installed” can be quite time consuming. to bypass this process you have to edit two files.
org.talend.updates.runtime and org.talend.updates.
And then change the lines like below.
Database & Job optimisation.
Select only required columns,
If input is oracle database then select cursors options in the advance tab of component tOracleInput component, it will be faster.
Use bulk load component for data load. ( it requires loader to be installed on machine where job runs)
Load data in chunks, by applying filters on select statement.
Add more memory on current hardware so job utilizes it for better performance.
Replace White space, New line, carriage return, and Tabs from string use below code.
Failed to create Java Virtual Machine
This is frequent error while working on Talend. you can overcome this by using following setting by editing
TOS_DI-Win32-r74687-V5.0.1.ini file. ( check for your version)
and modify following lines.
or you can modify following list.
If you think I am missing some other areas then do let me know.
I am Software consultant with approx 7 years of experience mainly in Business Intelligence and data warehousing assignments using Talend.
Writing is not my passion but i am doing it to help others. if you have any special case where you want me to demonstrate then please post me.