Pentaho PDI Fundamentals and DWH Concepts

BY
Udemy

Mode

Online

Fees

₹ 449 2299

Quick Facts

particular details
Medium of instructions English
Mode of learning Self study
Mode of Delivery Video and Text Based

Course and certificate fees

Fees information
₹ 449  ₹2,299
certificate availability

Yes

certificate providing authority

Udemy

The syllabus

Overview of data Warehousing

  • Overview of OLTP
  • Data Warehousing Concepts
  • Benefits and Limitations of Data Warehouse
  • ETL in Data Warehousing
  • ETL vs ELT

Overview of Dimensional Modeling

  • Dimensional Modeling Overview
  • Star Schema,Snowflake Schema and Galaxy Schema
  • Dimensional Modeling Design Steps

Pentaho Data Integration Input and Output Steps

  • Pentaho Data Integration Tool Installation Guide
  • Install Mysql and Connect to Pentaho
  • Pentaho Data Integration Components
  • PDI Input and Output Steps Part 01
  • PDI Input and Output Steps Part 02
  • PDI Input and Output Steps Part 03

Pentaho Data Integration Transformation Steps

  • Transformation Steps Part-01
  • Transformation Steps Part-02
  • Transformation Steps Part-03
  • Transformation Steps Part-04
  • Transformation Steps Part-05
  • Transformation Steps Part-06
  • Transformation Steps Part-07

Pentaho Data Integration Flow Transformation Steps

  • Flow Transformation Steps Part-01
  • Flow Transformation Steps Part-02
  • Flow Transformation Steps Part-03

Pentaho Data Integration Join Steps

  • Inner Join
  • Cartesian Product
  • Outer Joins
  • Pentaho Joins Steps Part-01
  • Pentaho Joins Steps Part-02

Pentaho Data Integration Transformation Steps Advance Level

  • Stream Lookup Step in Pentaho
  • Database Lookup Step in Pentaho
  • Database Join Step in Pentaho
  • Data Validation Step in Pentaho

Web Services

  • Consuming REST Service in Pentaho
  • Consuming SOAP Service in Pentaho

SCD & CDC Implementation in Pentaho

  • Slowly Changing Dimensions
  • SCD Type 1 Implementation
  • SCD Type 2 Implementation
  • Change Data Capture(CDC) Implementation
  • Change Data Capture - Method 2 Part-01
  • Change Data Capture - Method 2 Part-02

Pentaho Data Integration Steps

  • Overview of Jobs in Pentaho
  • Job Steps Part-02
  • Parameters and Variables in Pentaho
  • Parameter within Scope

Metadata ETL Injection Step Example

  • Pentaho Metadata Injection Part-01
  • Pentaho Metadata Injection Part-02

Trending Courses

Popular Courses

Popular Platforms

Learn more about the Courses

Download the Careers360 App on your Android phone

Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile

Careers360 App
150M+ Students
30,000+ Colleges
500+ Exams
1500+ E-books