Second ETL example - file to table | skillfic

Autoplay
Autocomplete

Previous Lesson Complete and Continue

Learn ETL with Pentaho kettle PDI - dev course #1

Welcome to the course

Thank you, some guide lines (3:02)
Your first ETL example - table to table (6:39)
First ETL explained (6:22)
Second ETL example - file to table (9:03)
Materials of the course (1:04)

Installations

Installations intro (1:36)
Download links of softwares
Install PDI (4:08)
Install JAVA (3:37)
Install Mysql (4:09)
Databases creation (8:21)
Install navicat (4:07)
Jdbc and connection (5:28)
Install notepad (1:03)

PDI Walkthrough

PDI Environment (11:20)
PDI jobs (7:52)
kettle.properties (8:35)
PDI shared.xml (2:42)

The Project

The project (6:06)
homework database (5:08)
Homework PDF

dim date

Dim date intro (2:24)
Generate rows step (5:49)
Add sequence step (1:49)
Calculator step (5:47)
Select values step (7:16)
String cut step (2:59)
Concat fields step (2:38)
String operation step (2:58)
Table output step (9:48)
Dim date homework (7:49)
Dim date homework answers (21:54)

Dim Time

Dim time intro (0:47)
Dim time final result (2:19)
Cartesian step (8:17)
String operation step (5:39)
Javascript / constant steps (8:30)
filter rows / table output steps part 1 (12:07)
filter rows / table output steps part 2 (15:15)
Dim time conclusion (4:13)
Dim time homework (9:50)
Dim time homework answers (32:34)

Dim Customers

Dim customers intro (4:21)
insert update step (21:30)

Dim Film

Dim film intro (7:27)
Dim film base (6:46)
Handling nulls (6:10)
Merge join step (5:27)
Stream lookup step (3:27)
De normilzer step (6:56)
Dim film consclution (9:39)
Dim film homework (3:27)
Dim film homework answers (32:35)

Dim store

Dim store intro (4:19)
lookup step part 1 (15:45)
lookup step part 2 (11:04)
insert update step (9:42)
Dim store homework (2:55)
Dim store homework answers (7:35)

Fact rental

Fact rentals intro (9:05)
lookups (10:14)
dates handling (18:32)
Fact rental payments (16:03)
Fact rental conclusion (3:33)
Fact rental homework (8:56)
Fact rental homework answers (2:16)

Main job

The main job part 1 (11:29)
The main job part 2 (7:11)
Schedule the main job (14:20)

Theory

analytical structure (12:33)
data sources part 1 (14:11)
data sources part 2 (16:46)
data warehouse (5:37)
etl_tools (17:59)
Theory section comments

Whats next...

Congrats and surprise (0:27)

Teach online with

Second ETL example - file to table

Complete and Continue