Preface
This IBM® Redbooks® publication documents the procedures for implementing IBM InfoSphere™ DataStage® and related technologies using a typical retail industry scenario.
It is aimed at IT architects, Information Management specialists, and Information Integration specialists responsible for developing IBM InfoSphere DataStage on a Red Hat Enterprise Linux® 4.0 platform.
The book offers a step-by-step approach to implementing IBM InfoSphere DataStage on Red Hat Enterprise Linux 4.0 platforms accessing information stored on IBM z/OS® and IBM AIX® platforms.
This book is organized as follows:
Chapter 1, “IBM InfoSphere DataStage overview” on page 1 provides an overview of IBM Information Server architecture and main components, IBM InfoSphere DataStage within the IBM Information Server architecture, and IBM InfoSphere DataStage’s main functions.- Chapter 2, “IBM InfoSphere DataStage stages” on page 35 provides an overview of some of the commonly used stages in IBM InfoSphere DataStage.
- Chapter 3, “Retail industry scenario” on page 139 describes a step-by-step approach to implementing a “real world” retail industry scenario involving a typical star-schema data warehousing flow using IBM InfoSphere DataStage. Included in the flow are the Complex Flat File, Distributed Transaction Stage, and Slowly Changing Dimension stage.
- Appendix A, “IBM Information Server setups” on page 563 describes the setups of various components required to implement the retail industry scenario.
- Appendix B, “Code and scripts used in the retail industry scenario” on page 597 documents some of the code and scripts used in the retail industry scenario.
The team that wrote this book
This book was produced by a team of specialists from around the world working at the International Technical Support Organization, San Jose Center.
Nagraj Alur is a Project Leader with the IBM ITSO, San Jose Center. He holds a Master’s degree in Computer Science from the Indian Institute of Technology (IIT), Mumbai, India. He has more than 33 years of experience in database management systems (DBMSs), and has been a programmer, systems analyst, project leader, independent consultant, and researcher. His areas of expertise include DBMSs, data warehousing, distributed systems management, database performance, information integration, and client/server and Internet computing. He has written extensively on these subjects and has taught classes and presented at conferences all around the world. Before joining the ITSO in November 2001, he was on a two-year assignment from the Software Group to the IBM Almaden Research Center, where he worked on Data Links solutions and an eSourcing prototype.
Celso Takahashi is a Technical Sales Specialist in IBM Brazil. He has 12 years experience in database management systems such as Informix® and Oracle®. He has done Proof of Concept (POC) projects involving IBM Information Server for customers in Brazil. His areas of expertise include DataStage, QualityStage, Information Analyzer, DataMirror, Business Glossary and Metadata Workbench. Celso has a Bachelor’s degree in Computer Science and an MBA degree in Project Management.
Sachiko Toratani is an IT Specialist providing technical support on IBM Information Platform products to customers in Japan. She has more than eight years experience in database management systems (DBMSs), and application development in government related systems. Her areas of expertise include Information Integration and DBMSs, with extensive skills in IBM Information Server, IBM InfoSphere DataStage, and DB2® for Linux®, UNIX®, and Windows®. She is IBM Certified in Database Administrator DB2 UDB for Linux, UNIX, and Windows.
Denis Vasconcelos is a Data Specialist with IBM Brazil. He had over five years experience with several non-IBM data management systems before joining IBM in 2006. His areas of expertise include database administration, data modeling, heterogeneous database migration, and project management. Denis has a Bachelor’s degree in Computer Science and a post-graduate degree in Project Management.
Thanks to the following people for their contributions to this project:
Aarti Borkar
Brian Caufield
Atul Chadha
Gary Faircloth
Jennifer Fell
Sreejith Kurup
Tamara Khaleel
Gaurav Rawal
Paul Stanley
Gregg Upton
IBM Silicon Valley Laboratory, San Jose
Paul Christensen
Tony Curcio
Ernie® Ostic
Barry Scott Rosen
Emily White
IBM USA
Carmen Ruppach
IBM Germany
Deepak Naik
IBM India
Become a published author
Join us for a two- to six-week residency program! Help write a book dealing with specific products or solutions, while getting hands-on experience with leading-edge technologies. You will have the opportunity to team with IBM technical professionals, Business Partners, and Clients.
Your efforts will help increase product acceptance and customer satisfaction. As a bonus, you will develop a network of contacts in IBM development labs, and increase your productivity and marketability.
Find out more about the residency program, browse the residency index, and apply online at:
ibm.com/redbooks/residencies.html
Comments welcome
Your comments are important to us!
We want our books to be as helpful as possible. Send us your comments about this book or other IBM Redbooks in one of the following ways:
- Use the online Contact us review Redbooks form found at:
- Send your comments in an e-mail to:
- Mail your comments to:
IBM Corporation, International Technical Support Organization
Dept. HYTD Mail Station P099
2455 South Road
Poughkeepsie, NY 12601-5400