DataStage Online Training

DataStage Course Content

  1. Data Warehouse Fundamentals
  • Data Marts
  • Introduction of Data warehousing
  • purpose of Data warehouse
  • Architecture of Data warehouse
  • OLAP & OLTP Methods
  1. Data Modeling
  • Introduction of Data Modeling
  • Entity Relationship Model
  • Types of Modeling (Logical & Physical)
  • Types of schema’s
  • Types of tables
  • Dimension & Fact table relationship.
  1. Process of ETL (Extraction, Transaction & Load)
  • Introduction of ETL
  • Types of ETL tools
  • Key tools in the market
  • Installation Process
  • Database and OS requirements
  • SMP & MPP
  1. Introduction of IBM Datastage
  • Datastage components
  1. a) Designer client
  2. b) Director client
  3. b) Administrator client
  4. c) Web Console
  • Datastge Parallelism
  • Portioning techniques
  • Creation of jobs & types of jobs
  • configuration files & Environment Variables
  • Parameters & parameter set
  • compilation & job run
  • Designer & Director Repository
  • Parallel Pallet
  1. a) General – link, containers
  2. b) File stages – Sequential files, Dataset etc
  3. c) Database stages – Oracle, DB2, ODBC connectors etc
  4. d) Processing stages
  • Filter
  • Sort
  • Aggregate
  • Join
  • Lookup
  • Merge
  • Transformer – Stage variables, Constraints, funtions
  • Aggregate
  • Copy
  • Change Capture
  • Change Apply
  • Funnel
  • Remove Duplicate
  • Surrogate Key Generator
  • Pivot stage
  • SCD stages and etc.
  1. e) Debugging stages – Peak, row generator, column generator etc.
  2. f) Quality stage – Investigate, Standardize, Match Frequency, Reference Match Stage etc.
  • Sequencer Pallet
  1. a) Job Activity
  2. b) Job sequencer
  3. c) Start loop Activity
  4. d) End loop Activity
  5. e) Notification Activity
  6. f) Terminator Activity
  7. g) Nested Condition Activity
  8. h) Exception handling Activity
  9. i) Execute Command Activity
  10. j) Wait for file Activity
  11. k) User variable Activity
  12. l) Adding Check Points
  13. m) Restart able

5 Job scheduling, monitoring, status check

6 Performance tuning techniques

7 RCP, Multiple instance

8 Import & export of DSX & DS job run using UNIX.

9 DataStage Administrator

  1. a) Create Project
  2. b) Delete Project
  3. c) Protect Project
  4. d) Permissions

10 Appendix

  • Real time complex scenarios and FAQ
  • Resume preparation
  • Interview & certification FAQS
  • How to face the interview
  • Project preparation with data analysis methods.