Talend Tips & Tricks

This post will contain Talend Tips & Tricks which saves your time while Coding, Java Converts, If Conditions, Expression Builder and many more area.

  • Always do Empty string and Null handling before converting.
!Relational.ISNULL(row1.StartDate) && row1.StartDate!=""?TalendDate.parseDate("yyyy-MM-dd", "2015-02-19"): TalendDate.parseDate("yyyy-MM-dd", "1999-01-01")
  •   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.

  1. Right Click on job from Repository.
  2. Select Option “Setup routine dependencies”.
  3. 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.
  4. see the Image for more details.
Exclude routines from Talend Build
Exclude routines from Talend Build

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.

System.out.println(foo.replaceAll("\\s+"," "));

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.

//change into
or you can modify following list. 


adding more….

If you think I am missing some other areas then do let me know.

About Umesh

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.

Leave a Reply

Your email address will not be published. Required fields are marked *