
Get basic knowledge and idea what ETL is.
Learn new steps
1) Get system info
2) Add constants
3) Select values
4) Blocking step
5) Update step
Learn how to connect your transformations with job.
1) Transformation Entry
2) Zip file Entry
3) Move Files Entry
4) Mail Entry
New step copy rows to result.
New settings on job, " Execute for each input row" explanation
New steps learned and how to use custom variables in root job:
1) Modified JavaScript value
2) String operations
3) If field value is null
4) Sort rows
5) Text file output
6) Fuzzy match
7) Set Variables
8) Get rows from the result
Course Title: Mastering Pentaho Data Integration (PDI) 9.4: From Installation to Best Practices
Course Description:
Welcome to "Mastering Pentaho Data Integration (PDI) 9.4: From Installation to Best Practices," a comprehensive guide to effectively using the latest version of PDI. This course provides step-by-step instructions for installing PDI 9.4 and offers an in-depth exploration of its Graphical User Interface (GUI).
You will learn to create robust transformations and jobs while adhering to industry best practices for production environments. Each section of the PDI GUI will be thoroughly explained to ensure you gain a complete understanding of the tool's capabilities.
What You Will Learn:
Installation: A detailed, step-by-step guide to installing PDI 9.4, ensuring a smooth setup.
PDI GUI Overview: An explanation of each section of the PDI GUI, enabling you to navigate and utilize the tool effectively.
Creating Transformations and Jobs: Learn to create data transformations and jobs with a focus on best practices for production environments.
Best Production Practices: Tips and techniques for optimizing your PDI workflows for reliability, efficiency, and maintainability.
Who Should Take This Course:
Data Integration Developers
ETL Developers
Data Engineers
Anyone interested in mastering PDI for data integration tasks
By the end of this course, you will be equipped with the knowledge and skills to install and use Pentaho Data Integration 9.4 effectively, ensuring your data integration projects are executed with best production practices.