Planet Jaspersoft

June 21, 2019

Load Data

rajeshsirsikar
Rajesh Sirsikar )

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…

June 21, 2019

Manage Order

rajeshsirsikar
Rajesh Sirsikar )

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…

June 21, 2019

Unpivot

rajeshsirsikar
Rajesh Sirsikar )

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…

June 21, 2019

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.…

June 21, 2019

June 20, 2019

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…

June 20, 2019

November 19, 2018

This blog is to explain how I achieved scrolling text on 2 zone FC16 display module (MAX7219) with Big Font and customizable text using a web page. I have used Parola library and the example code provided in it. Click here to download the Library.…

November 19, 2018

July 5, 2018

  Inspired by the visual treat of Blue Planet II series by BBC. We have created this re-score.

July 5, 2018

October 14, 2016

October 14, 2016

In a Datawarehouse setup, the quintessential decision needs to be taken is how to load the data. There are couple of standard ways in DW Full Load : Where the complete set of data will be loaded into DW table from source table…

October 14, 2016

October 4, 2016

RAJESH SIRSIKAR TECH LEAD Date of Birth 08July 1982 Address 125Mahaveer Calyx, Arekere Post 560076 Phone +91 – 9972212121 E-mail rajeshsirsikar.jaspe

October 4, 2016

Pages

Feedback