Temproal tables iz DWH ugla

Marković Vladimir

Ostali podaci

Data Platform & Business Intelligence
300
Na našem
14:00 - 15:00
018 (156)

Opis predavanja

Jedna od novina MS SQL 2016 je system-versioned temporal tables (ANSI SQL 2011) koja nam omugućava praćenje svih izmena nad tabelom. S druge strane, jedan od DWH izazova je jednostavno i brzo detektovati izmene koje su se desile nad tabelama od interesa za DWH rešenja. Tradicionalni pristup je izrada Change Data Capture sloja ETL koristeći replikaciju ili, ređe, direktno nad OLTP bazom.

Na ovom predavanju biće predstavljena nova funkcionalnost - temporal table iz DWH ugla. Kako pomoću temporal table napraviti CDC? Da li nam je klasičan CDC uopšte potreban? Da li se temproal tables mogu koristiti tako da kreirate SCD Type 1 a dobijete SCD Type 2 atribute?

Vladimir has comprehensive experience in DW/BI design and development primarily based on Microsoft and SAS BI platforms and products. This experience is further bolstered by years of working in implementation and development different kinds of DW/BI solutions and products.

During his work in the bank, he’s gained broad business background in different fields of BI application especially in analytical customer intelligence, credit risk scoring, credit risk portfolio management and accounting.

He is an experienced trainer and presenter.  He enjoys sharing enthusiasm by presenting and promoting DW/BI at courses, user groups, technical events and conferences.

Vladimir holds a MSc in Math and Computer Science from Faculty of Mathematics, University of Belgrade . Areas of his interest are dimensional modeling and data mining.  He plays chess in his free time.

Banka Intesa AD Beograd

Tarabica # IT Conference je najveća tehnička konferencija u Srbiji koju organizuju ljudi koji se profesionalno ili iz hobija bave Microsoft tehnologijama.