INTERVIEW QUESTIONS IN PENTAHO SET-3
Today, I will share few more set of questions that can be asked in Pentaho DI Interview. 1. How you will merge the rows in one row based with delimiter Continue Reading
Pentaho Data Integration Enterprise Edition Installation
Today, I will discuss about the installation process of Pentaho Data Integration Enterprise Edition(30 Days Trial Version) available on Pentaho Site. As the community version of Pentaho gives a lot Continue Reading
Check SQL History and Monitor Sessions in PL/SQL Developer Tool
Today, i will discuss about how to monitor Sessions and check what all queries executed in pl/sql Sessions. First, In order to Monitor Sessions which are active /inactive in particular Continue Reading
MERGE ROWS(DIFF) IN PENTAHO
Today, i will discuss about the component “Merge Rows(Diff)” in Pentaho. See the below transformation for the same. Before we start discussion on Merge Rows, always remember to sort the Continue Reading
HOW TO UPGRADE/UPDATE THE PENTAHO PLUGINS
Today, i will discuss about how to upgrade/update the Pentaho plugins. Pentaho is the Best ETL tool in my understanding and its open source version is very effective in a Continue Reading
DERIVED VARIABLES IN PENTAHO
Today, i will discuss about the Derived variables in Pentaho. The term “Derived Variables” means variable name or variable value derived from a particular variable or its value. In order Continue Reading
GET COLUMN NAMES ON WHICH INDEX IS CREATED IN ORACLE
Today, i will share the query which will give the column names along with table name on which index is created.Below is the Query for the same. select a.index_name,a.table_name,b.column_name from Continue Reading
INTERVIEW QUESTIONS IN PENTAHO SET-2
Today, i will discuss about the interview Questions on Pentaho. In my previous blog, I have share 15 Interview question. You can go through those as well using below link. Continue Reading
DEFECT METRICS
Today we will look at some of the Defect metrics which can help in effectively managing the project and identifying the pain areas. Defect Metrics drive information from defects raised Continue Reading
HOW TO GET FILENAMES PRESENT INSIDE THE ZIP FILE
Today, i will discuss about “How to get filenames present inside the zip file without unzipping it”. Here, “Get file names” component will be used. See the below image for Continue Reading