Schedule via Crontab | skillfic

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Master ETL with Pentaho kettle PDI #2

Welcome to the course

Notes about the course (3:02)
Material info (6:48)
Materials for the course (zip)

reminder (you can skip this section if you did level 1)

the project (6:06)
Database creation (7:17)
install Mysql (4:09)
PDI_install (4:08)

Variables and parameters

Variables intro (5:30)
Kettle properties (5:45)
Set variables (15:46)
Question mark (3:35)
Kitchen param (5:48)
Variables homework (4:18)
Variables homework answers (25:11)

Repositories

Repositories (25:12)
Git and PDI (18:57)

PDI on linux

Install PDI on ubuntu (14:09)
Schedule via Crontab (12:25)

Error Handling

Error handling (18:04)
Error handling Homework (1:16)
Error handling Homework Answers (9:05)

Loops - for each

For each in Jobs (14:17)
Homework loops (18:05)
Homework loops answers (3:09)

Slow changing dimension (SCD)

SCD intro (15:29)
SCD dimension lookup / update step (16:45)
SCD on fact table (9:53)

Logging and debugging

logging of transformation (8:25)
logging in run time (8:51)
logging to tables (34:42)
debug with the spider icon (4:58)
Logging Homework (3:41)
Logging Homework answers (4:49)

Bonus steps

Merge diff (8:24)
Serialize to file (7:22)
Group by (6:00)
Analytic query (8:32)
Analytic homework (1:22)
Analytic homework answers (3:37)
Serialize homework (2:43)
Serialize homework answers (1:17)

whats next...

Thank you (0:38)

Teach online with

Schedule via Crontab

Complete and Continue

Discussion

0 comments