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"

Create directory in Talend

Today, I'm goint to tell you, how we can create folders/directory in Talend

We use tSystem componet with commend-

"cmd /c mkdir C:\\path\\dir_to_make"

we can use many commend as per our requirement using tSystem component.

How to read password value from context variable in Talend

Hello,

By using tContextDump we can read all context values except passwords, tContextDump print passwords as ********** so how we can read that.

Let say we have a context variable CAT_Prod_Password which contains the password value.

So in order to read its value we can use tJava with below code-

System.out.println(context.CAT_Prod_Password);

Sample job screen shot-

Write table name automatically for table input/output components

Hello friends,
Today I'm going to tell you how we can save out time while working with table input and output components.

Its simple, just go to component Tab>>View and writhe __TABLE__ as label format and you will see table component will show table name automatically.

Memory allocation for talend

I updated my talend 5.4 version memory setting to get maximum speed for 4GB RAM



I used below values-

-vmargs
-Xms512m
-Xmx1536m
-XX:MaxPermSize=1024m
-Dfile.encoding=UTF-8


Try, it works!

How to get rid of file overwrite problem in Talend

Many times we see we lost the file's content while writing data into file multiple times. e.g. there is a excel file in which we are writing any data multiple time in some cases it only contains last date we have written, even after we used append option properly. So what is the solution.

here is a work a round solution.



rather writing directly on file you can first write in buffer output you all data and when all data will write use onSubjobOk trigger and use buffer input component in order to write your data in excel file.

this technique helped me a lot, hope you can also use this in your jobs :)

Automated Document Generation by Talend

Hello everyone,
Do you know Talend have a wonderful feature of creating job documentation automatically.
Here I'm going to tell you how you can create that.

Use following steps-

1. Go to repository tree view
2. Right click on you job for which you want to create document
3. Click on view documentation (see below image) to view doc
4. Click Generate Doc a HTML in order to create doc, use this one



 

click on finish button this will create a zip file, unzip that and you will find below files-


Click below URL to download a sample job doc which is created by Talend-
Here is Sample Document