datawarehouse and more
Jaspersoft Studio
This section of blogs contain all the workarounds and do hows on Jaspersoft Studio Community version.
Talend Open Studio
Talend is most sort after open source ETL tool in the market. This section is for my dive into this ocean
Music
How can I not have a section for Music in my site. I will post all the work I have been part of in this section.
Arduino & IoT
My new found passion. Have a long way to go. Read more for few work I have done in this category.

Load Data

In this final section we look at the data load. Here we will use the same tUnpivot row component to transpose the actual row data into columns and assign the column values from the column_config file. In this we will use the same…

Manage Order

This section is direct extraction from Bekwam Blog Here we will assign the value of primary columns to a HashMap object called fieldname. Input file is the same input file from tFileList tJaveRow has the code to assign values. The code is as…

Unpivot

This section is where we need to transpose the row structure of the config file to columns so that we can use it as a lookup table later. We use tFile delimited with Column values ranging from Column0¬†to ColumnN¬†with a key column added…

Create Column Mapping

In this section we will use the Limit property of tInputFileDelimited component and fetch only the column headers. then will load this into a file Set up of input file is as below. The key point to note here is the Limit option.…

Dynamic Schema in Talend Open Studio

This week got a request from one of my client to process over 100 csv files into one master file with a unique schema using TOS. There were multiple challenges. The schema of each file were different. These files were placed in different…