Tag Archives: ETL

Fragmented or Centralized Data

Posted on October 15, 2019 by way0utwest

I read a piece recently that talks about the hassles of copying data multiple times for different applications. In my experience, I haven’t seen this to be the main problem with data. It’s not often that we might replicate, in … Continue reading →

Posted in Editorial | Tagged , | 2 Comments

Self-Healing ETL

Posted on October 11, 2018 by way0utwest

The process of building ETL flows is cumbersome and time consuming. Many consultants have made a lot of money by building ETL processes that manage the movement of data in and out of databases, including to data warehouses. There is … Continue reading →

Posted in Editorial | Tagged , | Comments Off on Self-Healing ETL

Importing Flat Files in SSMS 17.x Works

Posted on September 12, 2018 by way0utwest

One of the more annoying things I’ve found in SSIS/SSMS is trying to import CSV files for some quick analysis. For some reason I constantly seem to get files that the import wizard keeps having issues. On top of that, … Continue reading →

Posted in Blog | Tagged , , | 2 Comments

ETL or ELT

Posted on April 3, 2018 by way0utwest

I was reading a piece on ETL patterns and found it interesting that the author noted that one way to reduce the challenge of ETL processes keeping up with changing schemas is to move to an ELT process. That’s an interesting perspective, and … Continue reading →

Posted in Editorial | Tagged | Comments Off on ETL or ELT