Check Number of fields in csv file in Pentaho
Today, I will discuss about the “How to check Number of fields in csv file or any other file in Pentaho without using shell Scripting. Below is the code snippet Continue Reading
Wildcard In pentaho
Today, I will discuss about the “Wildcards in Pentaho”. I have tried to cover all possible Scenarios. Use the below wildcard for below mentioned Scenarios. 1. Get all files present Continue Reading
Java Version for All Pentaho Versions
Today i will share the data for Java Version against Pentaho version. See the list below.It will help you in order to install correct Java version for Pentaho. PDI Version Continue Reading
Remove the extra delimiters in the file using shell script
Today, i will discuss about the “How to remove extra delimiters in a file” using shell script. Below is the content of the file. a|b||c d||e|||f Post execution of shell Continue Reading
CASE Statement in Pentaho
Today, I will discuss about how to create ETL(Pentaho) Equivalent of case statement in Database. In Pentaho, we have component “Number Range”. See the ETL Design for the same. In Continue Reading
Shell script to run for x hours using while Loop
Today i will discuss about the shell script code snippet which will run for x hours. Below is the code snippet which will help you to run code for x Continue Reading
AWS configuration files in Pentaho 8.2
Today, I will discuss about the configurations files which are newly introduced in Pentaho version >8. First of all, if you see in Pentaho version greater than 8, S3 file Continue Reading
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