Featured
-
How Regression Testing Detects Integral Errors In Business Processes
Humans are forever changing and evolving and so to
by kristina.rigina -
Get Display Banner Advertising Opportunity on FindNerd Platform
“Do you have a product or service that nee
by manoj.rawat -
Android O Released with Top 7 New Features for App Developers
Android was founded by Andy Rubin, Rich Miner, Nic
by sudhanshu.tripathi -
Top 5 Features That Make Laravel the Best PHP Framework for Development
Laravel is a free open source Web Framework of PHP
by abhishek.tiwari.458 -
Objective C or Swift - Which Technology to Learn for iOS Development?
Swift programming language is completely based on
by siddharth.sindhi
Tags
Create a Transformation in Pentaho
Hi Friends.
In this blog, I'm going to explain how you can create Transformations in Pentaho Spoon. I shall Extract data from a DBF file, will apply simple (no) Transformation and Load into MySql database. Pentaho comes with different comp...
PDI Components
There are four main components of Pentaho Data Integration tool:
1: SPOON
2: PAN
3: KITCHEN
4: CARTE
SPOON
It is a graphical design interface for buildings ETL jobs and transformation.
It provide a way to create complex ETL j...
How to send e-mail using Pentaho Kettle?
To send an e-mail:
Step1: Create a Job.
Step2: From Design menu, drag and drop Mail in your Job.
Step3: Right Click, Edit the Mail and set up Address, Server, Email Message, Attached File(if any).
Step4: Exec...
How to attach transformation log in Mail using Pentaho Kettle?
To attach a transformation log in Mail:
Step1: Right Click, edit the Transformation.
Step2: Go to Logging Settings.
Step3: Enable Specify Logfile, and provide the name and extension of file as below:
Step4: Go to Mail, edit the ...
How to insert data from CSV file to MYSQL DB using Pentaho
Step 1: Create an Input, drag and drop CSV File Input from Input step into your Transformation.
Right click, edit the Input file.
Provide File Name, click on Get Fields, then Preview to have a look in your input file.
Double check ...
