Datastage Online training
What is Data Stage?bout Us
DataStage® integrates data on demand across many systems via a high performance parallel framework, extended metadata management, and enterprise connectivity. It integrates data on demand with a high performance parallel framework, extended metadata management, and enterprise connectivity.Supports the collection, integration and transformation of large volumes of data, with data structures ranging from simple to highly complex.
Datastage Course Content
STEP-1 DATA WAREHOUSE FUNDAMENTALS
An Introduction of Data warehousing
Data ware Architecture
Data warehouse Lifecycle
STEP-2 COMPONENTS IN DATASTAGE
Administrator clint
Designer client
Director client
Import/export manager
Multi client manager
Console for IBM imformation server
Web console for IBM imformation server
STEP-3 INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X
Datastage Introduction
IBM Information server Architecture
IBM Data Quality Architecture
EnterpriseInformation Integration
Web Sphere DataStage Components
STEP-4 DATASTAGE DESIGNER
About Web Sphere DataStage 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)
OSHImporting Method
Configuration file
STEP-5 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
STEP-6 DS-DIRECTOR
About DS Director
Validation
Scheduling
Status
View logs
Monitoring
Suppress and Demote the Warnings
Peek view
STEP-7 DATASTAGE ADMINISTRATOR
Create Project
Delete Project
Protect Project
Environmental variables
Auto purge
RCP
OSH
Commands Execute
Multiple Instances
Job Sequence Settings
STEP-8 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
STEP-9 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