91. spotkanie Data Community Kraków
- 17:30 – 17:40 Rozpoczęcie spotkania, sprawy organizacyjne
- 17:40 – 18:40 Design and implement an ETL data flow by using an SSIS package - Izabela Krupa
- 18:40 – 19:00 Networking
- 19:00 - 20:00 Implement an ETL solution that supports incremental data extraction and data loading - Tomasz Libera
- 20:00 - 20:10 Zakończenie spotkania
Zapraszamy na trzecie spotkanie Study Group przygotowujące do egzaminu 70-767: Implementing a Data Warehouse using SQL organizowane przez Data Community - Kraków.
KIEDY
4 kwietnia (czwartek) godz. 17:30
ABSTRAKTY
Study Group przygotowuje do egzaminu 70-767: Implementing a Data Warehouse using SQL organizowane . Na spotkaniu będziemy omawiać następujące wymagania do egzaminu:
Design and implement an ETL data flow by using an SSIS package - Implement slowly changing dimension, fuzzy grouping, fuzzy lookup, audit, blocking, non-blocking, and term lookup transformations; map columns; determine the appropriate transform object for a given task; determine appropriate scenarios for Transact-SQL joins versus SSIS lookup; design table loading by using bulk loading or standard loading; remove extra rows or bad rows by using deduplication
Implement an ETL solution that supports incremental data extraction - Design fact table patterns, enable Change Data Capture, create a SQL MERGE statement
Implement an ETL solution that supports incremental data loading - Design a control flow to load change data, load data by using Transact-SQL Change Data Capture functions, load data by using Change Data Capture in SSIS