
Explore etl concepts with Pentaho data integration 9.4, including an overview, key features, and core components. Create simple transformations and jobs and build a real-time fuzzy match etl project.
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
Learn robust error handling with automatic startup and error notifications to developers via email, and direct logs to a dedicated log folder during job execution.
Enhance compute power of the fuzzy match job by moving data loading and normalization to the stage, avoiding repeated queries and bottlenecks.
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.