SCD Type 1 Implementation on Pentaho Data Integrator

This blog will talk about SCD Type 1 Implementation on Pentaho Data Integrator Slowly Changing Dimension Type 1 does not preserve any historical versions of the data . This methodology overwrites old data with new data, and therefore stores only the most current information. In this article let’s discuss the step by step implementation of …Read More

Jaspersoft Report Scheduler

This blog will talk about how to use Jaspersoft Report Scheduler, its configuration etc. 1.       Report Scheduler  :  It is an automated and iterative platform to email reports to anyone in PDF,CSV,Excel,….etc format.   2.       To  send email , it should be connected to outbound email server,  so for this it should be configured accordingly …Read More

INSTALL LIFERAY ON EXISTING TOMCAT 7

In this blog we will talk about how to install liferay on existing Tomcat 7. For this section, we will refer to your Tomcat server’s installation location as $TOMCAT_HOME. If you do not already have an existing Tomcat server, we recomend you download a Liferay/Tomcat bundle fromhttp://www.liferay.com/downloads/liferay-portal/available-releases. If you have an existing Tomcat server or would …Read More

How to solve pg_tblspc problem in postgres

This blog will talk about How to solve pg_tblspc problem in postgres Sometime when we are doing some operation on Postgres database, we faced this error. I faced  it,  when I  was  trying  to  get  values  from  database. This issue throws error that could not open directory “pg_tblspc/<1234…x>”: No such file or directory To  solve this  …Read More

Make Batch count for Incremental loading in Talend (TOS_5.3)

This blog will talk about how to make Batch count for Incremental loading in Talend (TOS_5.3). First all we have t_source and t_target tables Both Tables have (t_source,t_target) data like this…. Objective INSERT into t_source We inserted one record into t_source Insert into t_source(id,name,city,s_date) values (111,’vic’,’del’,’2014-03-01 01:02:00′) UPDATE from t_source We updated from t_source Update …Read More

Overcome Jasper Reports Complexities using PLPGSQL

This document is to help users to overcome jasper reports complexities using PLPGSQL (Postgres Stored Procedure function). Will look into the complexity with input controls of type multi-select query and how to cascade them. Creating a stored procedure function in plpsql, as we are dealing with multi-select query we need to create a stored procedure …Read More

D3 Calendar View Chart in Jaspersoft / iReport

This blog will talk about what is calendar view chart, its usage and about how to create and integrate a D3 Calendar View Chart in Jaspersoft / iReport All the reports are develop using ireport 5.5 professional and jasper server 5.5 As html component of jasper server does not load any scripts in the html …Read More

D3 Chord Diagram in Jaspersoft / iReport

This blog will talk about what is chord diagram, its usage and about how to create and integrate a D3 Chord Diagram in Jaspersoft / iReport All the reports are develop using ireport 5.5 professional and jasper server 5.5 As html component of jasper server does not load any scripts in the html component, we …Read More

Create CSV Data Sources in pentaho CDE: (Community Dashboard Editor)

This blog will talk about how to Create CSV Data Sources in pentaho CDE: (Community Dashboard Editor) Follow the steps to create CSV file as a Data sources. Step-1  Login to the User Console as an administrator. Step-2  Click Manage Data Sources. The Data Sources window appears. Step-3    Click the Add icon, then choose Data …Read More

Chart and it’s Usage

There are many broad categories of chart, this blog will highlight chart and it’s usage. This article will help a user to understand when what type of chart is to be used   a. Area Chart : Area chart should be used when we want to emphasize the magnitude of change over time. Area chart …Read More