memory heap error in Talend

How to overcome GC overload error

user these JVM_Arguments

-Xms1000M
-Xmx6G
-XX:+UseConcMarkSweepGC
-XX:+CMSIncrementalMode
-XX:SurvivorRatio=16

Printing error in Talend

Use following java code in tJava-

System.err.println("Hello this is error");

This will print Hello this is error
good for error printing.

Schema Issue Fix with tMap

If you have any Schema related error you are not able figure out the column name (good for huge number of columns)

Use the tMap and use Find option (top center) and get that specific column and change data type, size etc and fix the issue.

adding new component without component bar

just start typing component name at work area and  you will get matching components.

Talend Log file location

Hello friends,

Sometimes we get error, Talend is not starting and showing some error, in which dialog box says,
Open log file for details.

So now where from we get that log file, what is the file location?

the answer is following...

C:\TOS_505\Talend-Studio-20150128_1740-V5.5.2\workspace_dqtools_02\.metadata\.log

in above path workspace_dqtools_02 is workspace folder of your project (jobs) in that workspace folder we have .log file, which contains all error details.

We can resolve our issues using that .log file :)

How to use custom componet in Talend : tUnpivotRow

Hello friends,

here I'm going to use a custom component "tUnpivotRow", here are the steps, how one can load custom component in Talend.

above are the steps screenshots. Pic 1 we are setting component path. and in Pic 2 we are placing our custom component files. one can download this component from Talend Forge its free :)

Create unique filename using date function

Hello All,
We can use date function in order to make unique filename based on current date and time

"C:/Users/BRIJ/Desktop/Output/YouFileName_"+TalendDate.getDate("YYYY-MM-DD-hhMMss")+".xlsx"