Power Up Your Data Warehouse with Pre-ETL Processing

Erin Dempster

How often do you receive data from a 3rd party, and it isn’t in the format you need? Maybe it’s an Excel workbook and you need a JSON file, or it’s XML and you need a series of CSV files. Your ETL process is going to throw a hard stop on an unrecognized file format. This session will show the power and flexibility of PowerShell to handle different file formats and come out with a single, common format. We’ll start with built-in cmdlets and work our way up to customized routines to win the data format battle.