Appendix A: Flat File Data Sources

To test the examples in this book, you need the flat file data sources listed in Table B.1. All the files can be found in the ZIP file accompanying this book.

Table B.1: Flat files data sources and usage instructions
Open table as spreadsheet

No	File Name	Used In	Instruction
1	product2-1.txt	Chapter 2	Copy to the mysql\data\dw directory and rename to product.txt
2	product2-2.txt	Chapter 2	Delete product.txt, copy this file to mysql\data\dw directory, and change its name to product.txt
3	customer2.csv	Chapter 2	Delete customer.csv, copy this file to the mysql\data\dw directory, and change its name to customer.csv
4	customer8.csv	Chapter 8	Delete customer.csv, copy this file to the mysql\data\dw directory, and change its name to customer.csv
5	product8.txt	Chapter 8	Delete product.txt, copy this file to the mysql\data\dw directory, and change its name to product.txt
6	customer10.csv	Chapter 10	Delete customer.csv, copy this file to mysql\data\dw directory, and change its name to customer.csv
7	promo_schedule.csv	Chapter 11
8	campaign_session.csv	Chapter 16
9	ragged_campaign.csv cs v	Chapter 16
10	factory19.csv	Chapter 19	Copy to the mysql\data\dw directory and change its name to product.txt, and then change its name again to factory.csv
11	non_straight_campaign.csv cs v	Chapter 20
12	product21.txt	Chapter 21	Rename product.txt back to product8.txt, then rename this file to product.txt
13	zip_code.csv	Chapter 23
14	customer23.csv	Chapter 23	Rename customer.csv back to customer10.csv, then rename this file to customer.csv
15	factory23.csv	Chapter 23	Rename factory.csv back to factory19.csv, then rename this file to factory.csv

You should follow the instructions in the Instruction column carefully, especially when testing these three flat files, customer.csv, factory.csv, and product.txt.