DataStage Online Training

Data Warehousing‎ > ‎

DataStage Online Training Course Content:

1. DATA WAREHOUSE FUNDAMENTALS

· An Introduction of Data warehousing

· purpose of Data warehouse

· Data ware Architecture

· OLTP Vs Data warehouse Applications

· Data Marts

· Data warehouse Lifecycle

· SDLC

2. DATA MODELING

· Introduction of Data Modeling

· Entity Relationship Model

· Dimensions and Fast Tables

· Logical Modeling

· Physical Modeling

· Schemas Like Star Schema & Snowflake Schemas

· Fact less Fact Tables

3. PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)

· Introduction of Extraction , Transformation and Loading

· Types of ETL tools

· Key tools in the market

4. INSTALLATION PROCESS

· Windows server

· Oracle

· .NET

· Data stage 7.5X2 & 8x

5. DIFFERENCE
- Server jobs & Parallel jobs
6 . COMPONENTS IN DATASTAGE

· Administrator client

· Designer client

· Director client

· Import/export manager

· Multi client manager

· Console for IBM information server

· Web console for IBM information server

7. INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

· Data stage Introduction

· IBM Information server Architecture

· IBM Data Quality Architecture

· Enterprise Information Integration

· Web Sphere Data Stage Components

8. DATASTAGE DESIGNER

· About Web Sphere Data Stage Designer

· Partitioning Methods

· Partitioning Techniques

· Designer Canvas

· Central Storage

· Job Designing

· Creating the Jobs

· Compiling and Run the Jobs

· Exporting and importing the jobs

· Parameter passing

· System(SMP) & Cluster system(MPP)

· Importing Method(Flat file, Txt, Xls and Database files)

· OSH Importing Method

· Configuration file

9. PARALLEL PALETTE

· DATABASES STAGES

· Oracle Database

· Dynamic RDBMS

· ODBC

· SQL Server

· Teradata

· FILE STAGES

· Sequential File

· Dataset

· Lookup File set

· DEV/DEBUG STAGES

· Peek

· Head

· Tail

· Row Generator

· Column Generator

· PROCESSING STAGES

· Slowly changing dimension stage

· Slowly changing dimensions implementation

· Aggregator

· Copy

· Compress

· Expand

· Filter

· Modify

· Sort

· Switch

· Lookup

· Join

· Marge

· Change Capture

· Change Apply

· Compare

· Difference

· Funnel

· Remove Duplicate

· Surrogate Key Generator

· Pivot stage

· Transformer

CONTANERS

· Shared Containers

· Local Containers

10. DS-DIRECTOR

· About DS Director

· Validation

· Scheduling

· Status

· View logs

· Monitoring

· Suppress and Demote the Warnings

· Compiling and Run the jobs

· Peek view

11. DATASTAGE ADMINISTRATOR

· Create Project

· Delete Project

· Protect Project

· Environmental variables

· Auto purge

· RCP

· OSH

· Commands Execute

· Multiple Instances

· Job Sequence Settings

12. JOB SEQUENCE AREA

· Job Activity

· Job sequencer

· JS File

· Start loop Activity

· End loop Activity

· Notification Activity

· Terminator Activity

· Nested Condition Activity

· Exception handling Activity

· Execute Command Activity

· Wait for file Activity

· User variable Activity

· Adding Check Points

· Restorable

13. IBM WEB SPHERE QUALITY STAGE

· Data Quality

· Data Quality Stages

· Investigate Stage

· Standardize Stage

· Match Frequency Stage

· Reference Match Stage

· Unduplicated Match Stage

· Survive Stage

· Viewing audit details in operational DASHBOARD reports

KEY SERVICE

· FAQS

· Covering DBA concepts

· Concentration on performance tuning

· Real time scenarios

· Certification guidance

· Resume preparation

· Sample resumes

· Interview & certification FAQS

· How to face the interview

· Class notes which is useful for who is trying for job

· Project preparation