ETL software have ways to interpret XML files or structures that vary in maturity, but recently I had to find another way to import XML structures that are received as blobs using (transact) SQL only. Because the upstream patterns (Staging to Integration) can easily handle denormalised source data sets the easiest way was to cast each blob as the XML file it is anyway and completely denormalise it (‘flatten’, more rows…). This is opposed to normalising...
Search this site
Upcoming Training and Speaking Events
3-day Virtual Data Warehouse / Data Vault Implementation Training - Utrecht, The Netherlands - June 19-21 2019. Register here!
3-day Virtual Data Warehouse / Data Vault Implementation Training - Utrecht, The Netherlands - June 24-26 2019. Register here!
DDVUG Round Table - Munich, Germany - July 2nd 2019. Additional information here.
Metafinanz Data Warehouse Automation Day - Munich, Germany - July 3rd 2019.