filmov
tv
ETL SQL script to use Temporary or Staging tables #etl #sql
Показать описание
In this video, I have explained the advantages & disadvantages of Temporary tables & staging tables when it comes to writing ETL SQL scripts.
Knowing when to use which type of table can make or break your ETL pipeline.
Other recommended videos from my channel :
Learning SQL ? If you are learning SQL & looking for some help, then I will recommend you following videos:
If you like my videos, please subscribe the channel. I put lot of effort to create such videos and your engagement motivates me to come up with more such videos.
Video Timeline:
00:00 Introduction
01:04 Two options to write ETL SQL script
01:47 Temporary tables or Staging tables
02:25 Temporary tables - advantages & disadvantages
05:15 Staging tables - advantages & disadvantages
08:18 When to use Temporary tables or Staging tables
Knowing when to use which type of table can make or break your ETL pipeline.
Other recommended videos from my channel :
Learning SQL ? If you are learning SQL & looking for some help, then I will recommend you following videos:
If you like my videos, please subscribe the channel. I put lot of effort to create such videos and your engagement motivates me to come up with more such videos.
Video Timeline:
00:00 Introduction
01:04 Two options to write ETL SQL script
01:47 Temporary tables or Staging tables
02:25 Temporary tables - advantages & disadvantages
05:15 Staging tables - advantages & disadvantages
08:18 When to use Temporary tables or Staging tables
0:09:06
0:13:56
0:06:58
0:01:00
0:03:53
0:10:41
0:01:13
0:04:52
0:21:40
0:00:44
0:03:34
0:27:55
0:05:17
0:00:21
0:00:13
0:00:21
0:36:08
0:06:15
0:13:11
0:00:11
0:11:30
0:07:25
0:23:04
0:10:05