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 (5)

Related Courses

Oracle GoldenGate

14 Hours

Talend Administration Center (TAC)

14 Hours

Talend Big Data Integration

28 Hours

Talend Cloud

7 Hours

Talend Data Stewardship

14 Hours

Talend Open Studio for ESB

21 Hours

Sensor Fusion Algorithms

14 Hours

KNIME Analytics Platform for BI

21 Hours

Platforma analityczna KNIME - szkolenie kompleksowe

35 Hours

Pentaho Open Source BI Suite Community Edition (CE)

28 Hours

Pentaho Data Integration Fundamentals

21 Hours

Pentaho Business Intelligence (PBI) - moduły raportowe

28 Hours

Pentaho Data Integration (PDI) - moduł do przetwarzania danych ETL (poziom zaawansowany)

21 Hours

Related Categories