Loader
whatsapp

TRAINING

Enroll Now pentaho-training

Online Training

Corporate Training

ON Demand

Pentaho Training  

Pentaho Data Integration is an open-source data integration tool for defining jobs and data transformations.

In this instructor-led, live training, participants will learn how to use Pentaho Data Integration's powerful ETL capabilities and rich GUI to manage an entire big data lifecycle, maximizing the value of data to the organization.

By the end of this training, participants will be able to:

Create, preview, and run basic data transformations containing steps and hops Configure and secure the Pentaho Enterprise Repository Harness disparate sources of data and generate a single, unified version of the truth in an analytics-ready format. Provide results to third-part applications for further processing

Audience

  • Data Analyst
  • ETL developers
Pentaho Course Content

Introduction

  • Objectives & Class Logistics
  • What is Pentaho Data Integration (PDI)?

Transformation Basics

  • Learning the PDI User Interface
  • Creating Transformations
  • Generate Rows, Sequence, Select Values
  • Error Handling & Logging Introduction
  • Introduction to Repositories

READING & WRITING FILES

  • Input & Output Steps
  • Parameters & kettle.properties
  • CSV Input to Multiple Text Output Using Switch/Case
  • Serializing Multiple Text Files
  • De-serialize a File

WORKING WITH DATABASES

  • Connecting to & Exploring a Database
  • Table Input & Output
  • Reading & Writing to Database Tables
  • Insert, Update, & Delete Steps
  • Data Cleansing
  • Using Parameters & Arguments in SQL
  • Input with Parameters & Table Copy Wizard

DATA FLOWS & LOOKUPS

  •  Copying and Distributing Data
  • Parallel Processing
  • Lookups
  • Lookups & Data Formatting
  • Merging Data

CALCULATIONS

  • Designer
  • Using the Group By Step
  • Calculator
  • Calculating & Aggregating Order Quantity
  • Regular Expression
  • User Defined Java Expression
  • JavaScript

JOB ORCHESTRATION

  • Introduction to Jobs
  • Loading JVM Data into a Table
  • Sending Alerts
  • Looping & Conditions
  • Creating a Job with a Loop
  • Executing Jobs from a Terminal Window (Kitchen)

SCHEDULING

  • Setting up the Scheduler
  • Monitoring Scheduled Tasks)

EXPLORING DATA INTEGRATION REPOSITORIES

  • The Pentaho Data Integration Repository
  • Using the Pentaho Enterprise Repository

DETAILED LOGGING

  • I Detailed Logging throughout Execution

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services

United Global Soft Key Features

Expert Instructors

Practical Implementation

Real- time Case Studies

Certification Guidance

Resume Preparation

Placement Assistance

Copyright 2018 © www.unitedglobalsoft.com . All right reserved | Sitemap | Privacy Policy | Terms Of Services