Data Warehouse - TPC-DI

Installation

Tools

This project have be done with Visual Studio 2017 and a Microsoft SQL Database.

Installation

• First download the TPC-DI tool and generate data.
• Save the generated data in the following folder: C:\Users\Public\Documents\TPC-DI\Batch1 (see "Configuration" point for more informations).
• Copy also the file CustomerMgmt.xsd (in the same folder).
• Create a database destination_di on your local database and execute the file createTables.sql.

Configuration

• Database
  This project work with Microsoft SQL Database. This database is in localhost (use hostname .).
• Files
  All the files are store at the same place (which not user dependant). Indeed, we choose a "public" folder: C:\Users\Public\Documents\TPC-DI\Batch1

Files

• Splitting packages
  Package files: generally one file per table (used to work in group)
• CustomerMgmt.xsd Used by DimCustomer.dtsx to open XML file
• AllPackages.dtsx
  Contains all the ETL process
• TPC_DI__DW_2018__Part_2.pdf Report about this project
• createTables.sql
  Create destination database