Database Join Step in Pentaho With Examples
The database join step runs a query in the DB based on the input data returned from the previous step. It actually executes the query for e...
Showing posts with the label Pentaho
Data Grid Input Step Examples - Pentaho PDI
Vijay Bhaskar
The data grid step is used to generate static rows of data. This step is useful for writing status message to a log file or for inserting c...
CSV File Input Step Pentaho With Examples
Vijay Bhaskar
The CSV input step is used to read data from delimited files. It is a subset of the Text file input step. The CSV name for this step is inc...
Creating a Database Connection in Pentaho
Vijay Bhaskar
Before querying or loading data into the database one has to create a database connection. Let see first how to create a database connectio...
FireToDB Function - Run SQL Query in Pentaho Javascript
Vijay Bhaskar
The fireToDB function in the javascript step of pentaho data integration tool (kettle) is used to run an SQL statement in the database. The...
Date Validations in Pentaho Using Javascript Step - Kettle
Vijay Bhaskar
Data Validation is one of the common task in any ETL job. Sometimes we receive inconsistent data especially if the sources are log files. W...
Pentaho Carte Cluster Setup
Vijay Bhaskar
Carte is a web server used for running Pentaho's kettle transformations and jobs remotely. Carte web server is also used for monitoring...
Unable to Load Hive Server 2 JDBC Driver - Pentaho Kettle
Vijay Bhaskar
Q) How to resolve the error, "unable to load Hive Server 2 JDBC driver", when connecting to hive in pentaho's data integratio...