IBM InfoSphere DataStage Data Flow and Job Design

B

Code and scripts used in the retail industry scenario

In this appendix we document some of the code and scripts used in the retail industry scenario.

B.1 Introduction

This appendix documents some of the code and scripts used in the retail industry scenario, as follows:

• Figure B-1 here shows the entities and fields in WantThatStuff’s OLTP systems. Product and Store are VSAM files, while the others are sequential files.

• Example B-1 on page 599 shows the DDL for creating the tables in WantThatStuff’s star-schema data warehouse.

• Example B-2 on ...