Cloning Rows Using Pentaho Data Integration

Cloning Rows Using Pentaho Data Integration Cloning is a different kind of operation to replication and backups in which the cloned environment is both fully functional and separate in its own right. Additionally, the cloned environment may be modified at its inception due to configuration changes or data subsetting. When there is the need of cloning a certain number of rows Pentaho gives an inbuilt […]

Read More Leave comment

CASE INSENSITIVE UNIQUE ROWS IN PENTAHO

Today’s blog is about CASE INSENSITIVE UNIQUE ROWS IN PENTAHO i.e. whether a string is uppercase or lowercase in which we try to overcome this particular issue using Pentaho’s data integration tool KETTLE. The following steps will give you a brief overview of how things are done. 1.Initially, we took three sample data and summed it up to a dummy step. So we have all […]

Read More Leave comment

IMPLEMENTING MAP COMPONENT IN DASHBOARD IN PENTAHO BISERVER

How to Implementing Map Component In Dashboard in Pentaho Biserver This Blog is all about Implementing Map Component In Dashboard in Pentaho Biserver.The use of the map for accessing data from different regions is a newly implemented trend in the field of dashboarding where the Business user has the privilege to have a broader perspective on looking into the data from the Google maps. Pentaho has an inbuilt plugin […]

Read More Leave comment

USE OF CCC BULLET CHART COMPONENT USING PENTAHO CDE

This post talks about how to implement CCC Bullet Component in pentaho CDE. Pentaho CDE provides a numerous amount of plugin to enhance user end requirements on how to give different kinds of chat views to dashboards and reports.Among one of them is CCC Bullet Chart. The following description shows how to implement CCC bullet chart component in Pentaho CDE.

Read More Leave comment

DEFINING NUMBER RANGE IN PENTAHO DATA INTEGRATION

In arithmetic, the range of a set of data is the difference between the largest and smallest values. However, in descriptive statistics, this concept of range has a more complex meaning. The range is the size of the smallest interval which contains all the data and provides an indication of statistical dispersion.

Read More Leave comment

Setting null value to a constant using pentaho data integration

The  NULL is the term used to represent a missing value. A NULL value in a table is a value in a field that appears to be blank. A field with a NULL value is a field with no value. It is very important to understand that a NULL value is different than a zero value or a field that contains spaces.

Read More Leave comment

How to create file based repository in Spoon

In this blog we will learn about creating file based repository in Pentaho data integration tool – Spoon The following points focuses on why there is the need of using a repository:

Read More Leave comment

Removing Duplicates using Pentaho Data Integration

Today in this blog we are going to concentrate on removing duplicates using Pentaho Data Integration. This is a frequently asked question as to how one shall remove duplicacy issue which is quite cumbersome and creates a whole wide issue day in and out.

Read More 1 Comment

How to Define native JDBC connection in BA server

The issue of database connectivity is an age old process in the world of IT. But with Pentaho every such complexities can be overcome. After installing all the necessary JAR file we need to start our BA server.

Read More Leave comment

How to filter rows by using Pentaho data integration

In the field of Data Integration, coming across the issue of filtering incoming data from a source is a requirement that occurs regularly. The ETL process requires a lot of conditioning and filtering in order to overcome the data quality issues and all this processing may take a considerable amount of time if we go step by step. Pentaho gives us the best suitable inbuilt […]

Read More 1 Comment