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.



Dimensional Data Warehousing with MySQL. A Tutorial
Dimensional Data Warehousing with MySQL: A Tutorial
ISBN: 0975212826
EAN: 2147483647
Year: 2004
Pages: 149

Similar book on Amazon
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition)
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleanin
Successful Business Intelligence: Secrets to Making BI a Killer App
Successful Business Intelligence: Secrets to Making BI a Killer App

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net