IBM Infosphere Datastage Certification Training

✔ An Introduction of Data warehousing
✔ Purpose of Data warehouse
✔ Data ware Architecture
✔ OLTP Vs Data warehouse Applications
✔ Data Marts
✔ Data warehouse Lifecycle
✔ SDLC

✔ 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

✔ Introduction of Extraction, Transformation, and Loading
✔ Types of ETL tools
✔ Key tools in the market

✔ Windows server
✔ Oracle
✔ .NET
✔ Datastage 7.5X2 & 8x&9x

✔ Server jobs & Parallel jobs

✔ Administrator client
✔ Designer client
✔ Director client
✔ Import/export manager
✔ Multi-client manager
✔ Console for IBM information server
✔ Web console for IBM information server

✔ Datastage Introduction
✔ IBM Information server Architecture
✔ IBM Data Quality Architecture
✔ Enterprise Information Integration
✔ Web Sphere DataStage Components

✔ 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)
✔ OSH Importing Method
✔ Configuration file

✔ 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

✔ Containers

✔ Shared Containers
✔ Local Containers

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

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

✔ 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 the file Activity
✔ User variable Activity
✔ Adding Check Points
✔

1. Create Project
2. Delete Project
3. Protect Project
4. Environmental variables
5. Auto purge
6. RCP
7. OSH
8. Commands Execute
9. Multiple Instances
10. Job Sequence Settings

Restartable

✔ Data Quality
✔ Data Quality Stages
✔ Investigate Stage
✔ Standardize Stage
✔ Match Frequency Stage
✔ Reference Match Stage
✔ Unduplicated Match Stage
✔ Survive Stage