Datastage Online Training | Datastage Training | Datastage Course

INTRODUCTION TO DATAWARE HOUSE (DW)

DATA WAREHOUSING FUNDAMENTALS

Introduction of Data warehousing
purpose of Data warehouse
DW Architecture
Data warehouse vs. OLTP Applications
Data Mart
Data warehouse Lifecycle

DATA MODELING

Introduction of Data Modeling
Entity Relationship(ER) Model
Fact and Dimension Tables
Logical Modeling
Physical Modeling
Schemas – Star Schema & Snowflake Schemas
Fact less Fact Tables

PROCESS – ETL (EXTRACTION, TRANSACTION & LOAD)

Introduction of Extraction , Transformation and Loading (ETL)
Types of available ETL Tools
Key tools in the ETL market

INSTALLATION PROCESS (Datastage)

Windows server
Oracle
.NET
Datastage 7.5X2 & 8x

DIFFERENCE

Server jobs & Parallel jobs

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

INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

Introduction to Datastage
IBM Information server Architecture
IBM Data Quality Architecture
Enterprise Information Integration
Web Sphere Data stage Components

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

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

DS-DIRECTOR

About DS Director
Validation
Scheduling
Status
View logs
Monitoring
Suppress and Demote the Warnings
Peek view

DATASTAGE ADMINISTRATOR

Create Project
Delete Project
Protect Project
Environmental variables
Auto purge
RCP
OSH
Commands Execute
Multiple Instances
Job Sequence Settings

JOB SEQUENCE AREA

Job Activity
Job sequencer
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
Restartable

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