How to pass parameter in carte
Today, I will discuss about “Call Job using Carte with parameters”. I have already explained How to setup carte in windows machine and How to execute job or Transformation using Continue Reading
Query to get all records not matching in all tables.
Today, I will discuss about the scenario/Problem which i faced in current project. Problem Statement : You have two Employee tables having data mentioned below. Emp-1 EmpId EmpName 1 Shivani Continue Reading
Avro Output in Pentaho
Today, I will discuss about Avro Output Component in Pentaho. In my previous blog, I have share my experience about Avro input component where Data Deserialization happens. In this Component, Continue Reading
Avro File Input In Pentaho
Today, I will discussing about the Avro input component in Pentaho. Avro uses the concept of serialization and De-serialization. Serialization means processing the data into binary format. Its very clear Continue Reading
EDIT THE DATA IN HIVE TABLES
In Hive, We know that it works on file reading mechanism where hive reads data present in files present in hadoop file system. Here , pre-requisite is you should have Continue Reading
BEELINE COMMAND LINE IN HIVE
Today, I will discuss about the beeline command line which we use to call the SQL Query through Linux. But what if same thing needs to be called through Shell Continue Reading
INTERVIEW QUESTIONS IN PENTAHO SET-4
1.How to create ETL code which will behave same as case statement in Database. Name the component which you will use for the same. 2.Can we run the ETL code Continue Reading
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