Course Outline

The first day

  1. Installation and configuration Pentaho Data Integration
  2. Creating a repository
  3. Get to know the Spoon user interface
  4. Creating transformations
  5. Reading and writing to a file
  6. Working with databases (query generator SQL)
  7. Filtering, grouping and combining data
  8. Working with XLS

Day two

  1. Creating tasks
  2. Defining parameters and variables
  3. Data versioning (support for validity periods)
  4. Database transactionality in transformations
  5. Usage JavaScript
  6. Mapping transformations
  7. Data type conversion and column order in the stream
  8. Login processing

Day third

  1. Running transformations and tasks from the command line (kitchen.bat, pan.bat)
  2. Task scheduling
  3. Running transformations in parallel
  4. Remote startup (carte.bat)
  5. Clustering and partitioning
  6. Versioning and group work
 21 Hours

Number of participants


Price Per Participant (Exc. Tax)

Testimonials (2)

Provisional Courses

Related Categories