Datastage

Reading Time: 3 minutes

DataStage

Module 1: Introduction to Data Warehouse Concepts

  • What is Data Warehouse?
  • Data Mart
  • OLAP VS OLTP
  • Data Warehouse Architecture
  • What is Data Modelling?
  • Explorer on Dimensional Modelling
  • Explorer on Star Schema
  • Explain Snowflake Schema
  • Understanding on Dimension
  • Understanding on Fact
  • Slowly Changing Dimension
  • Lifecycle of Data Warehouse

Module 2: Understanding on ETL (EXTRACTION, TRANSACTION, LOAD)

Module 3: Overview of InfoSphere DataStage

Module 4: Install and Configuration on InfoSphere DataStage

Module 5: Working with DataStage Designer

Module 6: DataStage Job

Module 7: DataStage Director

Module 8: Creating Parallel Job

Module 9: Handle Files & data

Module 10: File Stages

Module 11: Combining and Partitioning Data

Module 12: Sorting and Aggregating Data

Module 13: Transformation on Data

Module 14: Get ready for interviews