Pentaho Data Integration Fundamentals | Online Training - Mildain
  • penatho data intgration

Pentaho Data Integration Fundamentals Training

Why take Pentaho and Integration Online Training ?

  • There is an excessive need for professionals skilled in data integration for better salary and excellent job opportunities.

  • There is an excessive need for professionals skilled in data integration for better salary and excellent job opportunities.

Product Description

  • Training Course

The volume, variety and velocity of data are increasing rapidly.  Organizations need fast and easy-to-use tools to harness data for actionable insight. One of the biggest challenges facing organizations today is the requirement to provide a consistent, single version of the truth across all sources of information in an analytics-ready format.

With powerful data extract, transform and load (ETL) capabilities, an intuitive and rich graphical design environment, and an open and standards-based architecture, Pentaho Data Integration is increasingly the choice over proprietary and homegrown data integration tools.

Pentaho Data Integration provides a full ETL solution, including:

  • Rich graphical designer to empower ETL developers
  • Broad connectivity to any type of data, including diverse and big data
  • Enterprise scalability and performance, including in-memory caching
  • Big data integration, analytics and reporting, including Hadoop, NoSQL, traditional OLTP & analytic databases
  • Modern, open, standards-based architecture

Through a series of lectures and hands-on exercises covering theory, best practices, and design patterns, Pentaho Data Integration Fundamentals provides students the skills they need to maximize the value of data to the organization.


  • MODULE 1: INTRODUCTION TO PENTAHO DATA INTEGRATION

Lesson 1: Objectives & Class Logistics

Lesson 2: What is Pentaho Data Integration (PDI)?


  • MODULE 2: TRANSFORMATION BASICS

Lesson 1: Learning the PDI User Interface

Lesson 2: Creating Transformations

Exercise 1: Generate Rows, Sequence, Select Values

Lesson 3: Error Handling & Logging Introduction

Lesson 4: Introduction to Repositories

  • MODULE 3: READING & WRITING FILES

Lesson 1: Input & Output Steps

Lesson 2: Parameters & kettle.properties

Exercise 2: CSV Input to Multiple Text Output Using Switch/Case Exercise 3: Serializing Multiple Text Files

Exercise 4: De-serialize a File

  • MODULE 4: WORKING WITH DATABASES

Lesson 1: Connecting to & Exploring a Database Lesson 2: Table Input & Output

Exercise 5: Reading & Writing to Database Tables Lesson 3: Insert, Update, & Delete Steps

Lesson 4: Data Cleansing

Lesson 5: Using Parameters & Arguments in SQL Exercise 6: Input with Parameters & Table Copy Wizard

  • MODULE 5: DATA FLOWS & LOOKUPS

Lesson 1: Copying and Distributing Data

Exercise 7: Parallel Processing

Lesson 2: Lookups

Exercise 8: Lookups & Data Formatting

Lesson 3: Merging Data

  • MODULE 6: CALCULATIONS

Lesson 1: Using the Group By Step

Lesson 2: Calculator

Exercise 9: Calculating & Aggregating Order Quantity Lesson 3: Regular Expression

Lesson 4: User Defined Java Expression

Lesson 5: JavaScript

  • MODULE 7: JOB ORCHESTRATION

Lesson 1: Introduction to Jobs

Exercise 10: Loading JVM Data into a Table Lesson 2: Sending Alerts

Lesson 3: Looping & Conditions

Exercise 11: Creating a Job with a Loop

Lesson 4: Executing Jobs from a Terminal Window (Kitchen)

  • MODULE 8: SCHEDULING

Lesson 1: Setting up the Scheduler

Lesson 2: Monitoring Scheduled Tasks

  • MODULE 9: EXPLORING DATA INTEGRATION REPOSITORIES

Lesson 1: The Pentaho Data Integration Repository

Exercise 12: Using the Pentaho Enterprise Repository

  • MODULE 10: DETAILED LOGGING

Lesson 1: Detailed Logging throughout Execution

  • Approx 01 Weeks

  • Sessions:-12 Sessions (each session of 02 hours)

Mildain Solutions

Plot No 17, C Block Market, Sec 36,
Noida (U.P.)-201301(India)
(+91) 1204326873
(+91) 7834800821
Contact Us

Your Name (required)

Your Email (required)

Contact Number

Course

Location

Query

Reviews

There are no reviews yet.

Be the first to review “Pentaho Data Integration Fundamentals Training”

Your email address will not be published. Required fields are marked *

Grab Corporate/Online Training at best Cost.