Book description
IBM Information Server is a revolutionary new software platform that helps organizations derive more value from the complex heterogeneous information spread across their systems. It enables organizations to integrate disparate data and deliver trusted information wherever and whenever needed, in line and in context, to specific people, applications, and processes.
IBM InfoSphere™ DataStage® is a critical component of the IBM Information Server, and the parallel framework of IBM InfoSphere DataStage is also the foundation for IBM InfoSphere QualityStage and IBM InfoSphere Information Analyzer components.
This IBM® Redbooks® publication develops usage scenarios that describe the implementation of IBM InfoSphere DataStage flow and job design with special emphasis on the new features such as the distributed transaction stage (DTS) in Version 8.0.1, slowly changing dimensions stage ( Version 8.0.1), complex flat file stage (Version 8.0.1), and access to mainframe data.
Table of contents
- Cover Page
- Title Page
- Copyright Page
- Figures
- Tables
- Examples
- Notices
- Preface
- Chapter 1. IBM InfoSphere DataStage overview
-
Chapter 2. IBM InfoSphere DataStage stages
- 2.1 Introduction
- 2.2 Aggregator
- 2.3 Complex Flat File
- 2.4 Column Import
- 2.5 Column Export
- 2.6 Data Set
- 2.7 Distributed Transaction (new in Version 8.1)
- 2.8 FTP Enterprise
- 2.9 Funnel
- 2.10 Join
- 2.11 Lookup
- 2.12 Merge
- 2.13 Sequential File
- 2.14 Slowly Changing Dimension
- 2.15 Sort
- 2.16 Surrogate Key Generator
- 2.17 Transformer
- Chapter 3. Retail industry scenario
- Appendix A. IBM Information Server setups
- Appendix B. Code and scripts used in the retail industry scenario
- Appendix C. Additional material
- Related publications
- Index
- Footnotes
Product information
- Title: IBM InfoSphere DataStage Data Flow and Job Design
- Author(s):
- Release date: July 2008
- Publisher(s): IBM Redbooks
- ISBN: 9780738431116
You might also like
book
Data Warehousing For Dummies®, 2nd Edition
Data warehousing is one of the hottest business topics, and there’s more to understanding data warehousing …
book
The Data Warehouse Lifecycle Toolkit
The world of data warehousing has changed remarkably since the first edition of The Data Warehouse …
book
Oracle Database 12c Release 2 Performance Tuning Tips & Techniques
Proven Database Optimization Solutions―Fully Updated for Oracle Database 12c Release 2 Systematically identify and eliminate database …
book
T-SQL Window Functions: For data analysis and beyond, 2nd Edition
Use window functions to write simpler, better, more efficient T-SQL queries Most T-SQL developers recognize the …