Data Stage Training

Datastage Online Training

Data Warehouse Fundamentals

  • An introduction to Data Warehousing
  • Purpose of Data Warehouse
  • Data Warehouse Architecture
  • Operational Data Store
  • OLTP Vs Warehouse Applications
  • Data Marts Data marts Vs Data Warehouses
  • Data Warehouse Life cycle

Data Modeling

  • Introduction to Data Modeling
  • Entity Relationship model (E-R model)
  • Data Modeling for Data Warehouse
  • Dimensions and fact tables
  • Star Schema and Snowflake Schemas

ETL Design Process

  • Introduction to Extraction,
  • Transformation & Loading
  • Types of ETL Tools
  • Key tools in the market

Data Stage Installation

  • Data stage Installation
  • Prerequisites to install Data stage
  • Installation process

Introduction to Data stage Version 8.1

  • Data stage introduction
  • IBM information Server architecture
  • Data Stage component
  • Data Stage main functions
  • Client components

Data stage Administrator

  • Data stage project Administration – Editing projects and Adding Projects
  • Deleting projects Cleansing up project files
  • Global variable setting – Environment management
  • Auto purging – Runtimes Column Propagation (RCP)
  • Add checkpoints for sequencer – NLS configuration
  • Generated OSH (Orchestra Engine) – System formats like data,
  • Timestamp – Project protect – Version details.

Data stage Director

  • Introduction to Data stage Director – Validating Data stage Jobs
  • Executing Data stage jobs – Job execution status
  • Monitoring a job – Job log view – job scheduling
  • Creating Batches – Scheduling batches

Data stage Designer

  • Introduction to Data stage Designer – Importance of Parallelism
  • Pipeline Parallelism – Partition Parallelism
  • Partitioning and collecting – Partition techniques
  • Data stage Repository Palette – Passive and Active stages
  • Job design overview – Designer work area
  • Annotations – Creating jobs – Importing flat file definitions
  • Dataset Overview

Working with Parallel Job Stages

  • Database Stages
  • Oracle – Teradata – ODBC – dynamic RDBMS

File Stages

  • Sequential file – Dataset – File set – Lookup file set

Processing Stages

  • Copy – Filter – Funnel – Sort Remove duplicate
  • Aggregator – Modify – Compress – Expand – Decode
  • Encode – Switch – Pivot stage – Lookup
  • Join – Merge – difference between look up,
  • Join and merge – change capture – Change apply
  • Compare – Difference – Surrogate key generator
  • Transformer

Debug Stages

  • Head – Tail – Peek – Column generator
  • Row generator

Real Time Stages

  • XML input – XML output, Java packs,
  • Web service packs

Local and Shared containers

Advanced Stages in Parallel Jobs (Version 8.1)

  • Range Look process – Surrogate key generator stage
  • Slowly changing dimension stage – away stage
  • FTP stage – Java plug in – Job performance analysis
  • Resource estimation
  • Slowly Changing Dimensions implementation
  • Performance tuning

Job Sequencers

  • Arrange job activities in Sequencer
  • Triggers in Sequencer – Restablity
  • Recoverability – Notification activity
  • Terminator activity
  • Wait for file activity Start Look activity
  • Execute Command activity – Nested Condition activity
  • Exception handling activity – User Variable activity
  • End Loop activity – Adding Checkpoints

Send Enquiry

Your Name (required)

Your Email (required)

Your Phone No. (required)

Subject

Your Message