• Rajesh Sirsikar

Blog

Talend BD – Using Googledrive Components

28
Mar,2020

0

Hi All, Find detailed post about steps to be taken to create a connection to your google drive using Talend. 1. Obtain access token to your google drive account. a. Go to Google API Console b. Create a new project,…

Load Data

21
Jun,2019

0

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…

Manage Order

21
Jun,2019

0

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…

Unpivot

21
Jun,2019

0

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…

Create Column Mapping

21
Jun,2019

0

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…

Dynamic Schema in Talend Open Studio

20
Jun,2019

0

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…

LED Matrix Display – Big Font using MAX7219 and ESP8266

19
Nov,2018

0

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…

Blue Planet II (Rescore)

5
Jul,2018

0

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

Contexts – Talend Open Studio

14
Oct,2016

0

Incremental Load – Talend Open Studio – Part 1

14
Oct,2016

0

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…