91. spotkanie Data Community Kraków - Study Group 70-767 #3

This is a past event

33 people went

Location image of event venue

Details

Zapraszamy na trzecie spotkanie Study Group przygotowujące do egzaminu[masked]: Implementing a Data Warehouse using SQL organizowane przez Data Community - Kraków.

KIEDY
4 kwietnia (czwartek) godz. 17:30

AGENDA
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 - Tomasz Libera
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

ABSTRAKTY
Study Group przygotowuje do egzaminu[masked]: 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