Pentaho Data Integration Course Content
Module 1
- Dimensional modeling
- Dimensional deign
- Star schema-what and by (model)
- Star schema –what and by (language)
- Conformed dimensions
- Additive vs. semi-additive facts
- Snow flake schema
- Star vs. Dimensional schema
- Slowly changing dimensions.
Module 2
- Clustering in pentaho
- Files in pentaho
- Spoon.bat
- Pan.bat
- Kitech.bat
- Spoon transformation and its steps of transformation
- How to create a connection in DB
- How to move a data from CSV file input to table output
- How to move the data from CSV file input to the Microsoft excel output
- How to move the data from Microsoft excel input to write to log
- Data Grid
- Generate rows
Module 3
- Data transformation-changing the data from one form to another form
- How to add constant
- How to add sequence
- Add value field changing sequence
- How the calculator work in pentaho
- No. range in pentaho
- Replace in string
- Select values-select field value
- Select field value to constant
- Sort rows
- Split field to rows
- String operation-string cut
- Unique rows
- Unique rows (hash set)
- Value mapper
Module 4
- Revision of SSH command
- How to handle the null value in pentaho
- Mail in pentaho
- Error handling in pentaho
- Flow
- Filter rows
- Priorities stream
Module 5
- Implementation of Slowly changing dimension
- Jobs
- Differences between jobs and transformation
- How to make ETL dynamic
- How to make transformation dynamic
- File management
- Create folder
- Conditions
- Scripting
- Bulk loading
- XML
- Utility
- Repository
- File transfer
- File encryption
Module 6
- How to make ETL dynamic
- Difference between parameter and variable
- How to pass a variable from a job to transformation
- Hoe to use a parameter within a transformation
- How to set and get the value from a job to a transformation
- Environmental variable
- Functionality of repository in pentaho
- Types of repository in pentaho
- Data base connection
- Repository import
Module 7
- Introduction to Big-Data Pluggin
- Hands on with Big-Data Pluggin
- How to set-up environment for PDI on cloud
- How to execute transformation and job from Cloud