Data Stage Online Training

[cssadhar]

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

 

Contact Us:309-200-3848