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.
No | File Name | Used In | Instruction |
---|---|---|---|
1 | product2-1.txt | Chapter 2 | Copy to the mysqldatadw directory and rename to product.txt |
2 | product2-2.txt | Chapter 2 | Delete product.txt, copy this file to mysqldatadw directory, and change its name to product.txt |
3 | customer2.csv | Chapter 2 | Delete customer.csv, copy this file to the mysqldatadw directory, and change its name to customer.csv |
4 | customer8.csv | Chapter 8 | Delete customer.csv, copy this file to the mysqldatadw directory, and change its name to customer.csv |
5 | product8.txt | Chapter 8 | Delete product.txt, copy this file to the mysqldatadw directory, and change its name to product.txt |
6 | customer10.csv | Chapter 10 | Delete customer.csv, copy this file to mysqldatadw directory, and change its name to customer.csv |
7 | promo_schedule.csv | Chapter 11 | |
8 | campaign_session.csv | Chapter 16 | |
9 | ragged_campaign.csv | Chapter 16 | |
10 | factory19.csv | Chapter 19 | Copy to the mysqldatadw directory and change its name to product.txt, and then change its name again to factory.csv |
11 | non_straight_campaign.csv | 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.
18.191.147.77