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
Kitchen param
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock