Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Advanced Transformation Building Blocks
- Handling complex data types with precision.
- Managing fields, metadata, and dynamic structures effectively.
- Developing reusable transformation patterns.
Parameters, Variables, and Job-Oriented Design
- Controlling runtime variables and their scope.
- Parameterizing transformations for flexibility.
- Structuring parent-child job hierarchies.
Database Integration and Lookup Strategies
- Leveraging advanced lookup steps.
- Implementing efficient caching strategies.
- Designing optimized joins for better performance.
Working with Files, APIs, and External Systems
- Processing JSON and XML data formats.
- Interacting with REST and SOAP web services.
- Managing both streaming and batch loading workflows.
Error Handling and Data Quality Techniques
- Capturing and appropriately routing errors.
- Establishing robust data validation patterns.
- Enhancing auditing and logging capabilities.
Performance Tuning Essentials
- Optimizing step design for efficiency.
- Considering memory usage and threading implications.
- Identifying and resolving performance bottlenecks.
Introduction to Repository-Based Development
- Utilizing the Pentaho repository effectively.
- Managing version control.
- Adopting best practices for team collaboration.
Deployment and Migration Practices
- Promoting jobs across different environments.
- Managing configurations securely and consistently.
- Following operational best practices for deployment.
Summary and Next Steps
Requirements
- Familiarity with core ETL fundamentals.
- Practical experience using Pentaho Data Integration.
- Foundational understanding of data warehousing concepts.
Target Audience
- ETL developers.
- Data engineers.
- Technical professionals seeking to deepen their PDI expertise.
21 Hours
Testimonials (1)
It's a hands-on session.
