Course Name     :  Datastage online training

Course Duration :  40 Hours

Data Stage

STEP-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

STEP-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

STEP-3 PROCESS OF ETL (EXTRACTION, TRANSACTION @LOAD)

• Introduction of Extraction , Transformation and Loding
• Types of ETL tools
• Key tools in the market

STEP-4 INSTALLATION PROCESS

• Windows server
• Oracle
• .NET
• Datastage 7.5X2 & 8x

STEP-5 DIFFERENCE

• Server jobs & Parallel jobs

STEP-6 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-7 INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

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

STEP-8 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)
• OSH Importing Method
• Configuration file

STEP-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

STEP-10 DS-DIRECTOR

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

STEP-11 DATASTAGE ADMINISTRATOR

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

STEP-12 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-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