Course Outline

Pentaho DATA iNTEGRATION

The first day

    Installation and configuration of Pentaho Data Integration Creating a repository Getting to know the Spoon user interface Creating transformations Reading and writing to a file Working with databases (query generator SQL) Filtering, grouping and combining data Working with XLS Creating tasks Defining parameters and variables

Day two

    Data versioning (support for validity periods) Database transactionality in transformations Usage JavaScript Mapping transformations Conversion of data types and the order of columns in the stream Login processing Running transformations and tasks from the command line (kitchen.bat, pan.bat) Task scheduling Running transformations in parallel

Requirements

Ogólna wiedza matematyczna.

 14 Hours

Number of participants



Price per participant

Testimonials (4)

Related Courses

Related Categories