ETL/ELT In The Cloud Using Data Factory
Trainer(s): Dennes Torres
Provider: DPS 2022 (Data Platform Summit)
Duration: 8 Hours
Subtitles: Yes
Regular Price: USD 299
Offer Price: USD 74.75 (75% OFF)
Discount Code: HAPPY75
(GST + Internet Transaction Fee additional)
Subscription Period: Lifetime Access
Abstract: Data Factory is a powerful member of the Azure data platform. We can build powerful ETL solutions with no code and migrate existing on premise SSIS solutions to the cloud.
Come to this full day session to discover how it works and what you can build. This demo-packed preconference will show many different examples and scenarios illustrating common ETL/ELT challenges in an enterprise data platform.
Modules:
- Data Factory – Basic Concepts
- The Flexibility of the Copy Data Activity
- Download from the web using the Web Activity
- Datasets
- Managing Source and Destination Datasets
- Azure SQL Datasets
- Azure Storage Datasets
- Using Schema Drift
- Creating the destination Schema
- Dataflows
- PowerQuery
- Data Factory Examples
- Incremental Loading Data
- Loading data into Slowly Changing Dimensions
- Managing the Development
- Managing Execution
- SSIS