Get in Touch

Course Outline

Advanced Transformation Components

  • Handling complex data types
  • Managing fields, metadata, and dynamic structures
  • Establishing reusable transformation patterns

Parameters, Variables, and Job-Centric Architecture

  • Runtime variable management and scoping
  • Techniques for parameterizing transformations
  • Structuring parent-child job hierarchies

Database Connectivity and Lookup Optimization

  • Advanced lookup step configurations
  • Strategic caching approaches
  • Designing efficient join operations

Integration with Files, APIs, and External Interfaces

  • Processing JSON and XML data formats
  • Interacting with REST and SOAP services
  • Managing streaming and batch loading processes

Error Management and Data Quality Assurance

  • Effective error capture and routing mechanisms
  • Implementing data validation patterns
  • Comprehensive auditing and logging strategies

Performance Optimization Fundamentals

  • Refining step design for efficiency
  • Considerations for memory usage and threading
  • Identifying and resolving performance bottlenecks

Repository-Based Development Initiatives

  • Leveraging the Pentaho repository features
  • Implementing version control practices
  • Facilitating team collaboration workflows

Deployment and Migration Protocols

  • Promoting jobs across various environments
  • Managing configuration settings
  • Adhering to operational best practices

Conclusions and Future Directions

Requirements

  • Familiarity with core ETL principles
  • Practical experience using Pentaho Data Integration
  • Foundational understanding of data warehousing concepts

Target Audience

  • ETL developers
  • Data engineers
  • Technical specialists looking to deepen their PDI expertise
 21 Hours

Custom Corporate Training

Training solutions designed exclusively for businesses.

  • Customized Content: We adapt the syllabus and practical exercises to the real goals and needs of your project.
  • Flexible Schedule: Dates and times adapted to your team's agenda.
  • Format: Online (live), In-company (at your offices), or Hybrid.
Investment

Price per private group, online live training, starting from 3900 € + VAT*

Contact us for an exact quote and to hear our latest promotions

Testimonials (1)

Provisional Upcoming Courses (Contact Us For More Information)

Related Categories