Datastage

COURSE NAME :  DATA STAGE Online Training

COURSE DURATION :  25 HOURS

• 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 Loding
• Types of ETL tools
• Key tools in the market

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

• Server jobs & Parallel jobs

• Administrator clint
• Designer client
• Director client
• Import/export manager
• Multi client manager
• Console for IBM imformation server
• Web console for IBM imformation server

• Datastage Introduction
• IBM Information server Architecture
• IBM Data Quality Architecture
• EnterpriseInformation 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)
• OSHImporting 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

• 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 file Activity
• User variable Activity
• Adding Check Points
• Restartable

• 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

• 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

Fill up quick inquiry form to get more details on Datastage online training