DATASTAGE Online Training

 >>  DATASTAGE Online Training

DATASTAGE Online Training


 (4.9) | 450 Ratings


Introduction


DATASTAGE Online Training Details
Track Regular Track Weekend Track Fast Track
Course Duration 35 Hrs 8 Weekends 5 Days
Hours 1hr/day 2 Hours a day 6 Hours a day
Training Mode Online Classroom Online Classroom Online Classroom
Delivery Instructor Led-Live Instructor Led-Live Instructor Led-Live


Course Curriculum

DATASTAGE Online Training Course Modules

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
  • DLC

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

Process of ETL (Extraction, Transaction &Load)

  • Introduction of Extraction , Transformation and Loading
  • Types of ETL tools
  • Key tools in the market INSTALLATION PROCESS
  • Windows server
  • Oracle
  • .NET
  • Datastage 7.5X2 & 8x

Difference

  • Server jobs & Parallel jobs
  • COMPONENTS IN DATASTAGE
  • Administrator Clint
  • 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

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

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

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
  • estartable

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

Exam & Certification

0

Course Review

(4.9)
5 stars
4 stars
3 stars
2 stars
1 stars

Course Curriculum

DATASTAGE Online Training Course Modules

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
  • DLC

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

Process of ETL (Extraction, Transaction &Load)

  • Introduction of Extraction , Transformation and Loading
  • Types of ETL tools
  • Key tools in the market INSTALLATION PROCESS
  • Windows server
  • Oracle
  • .NET
  • Datastage 7.5X2 & 8x

Difference

  • Server jobs & Parallel jobs
  • COMPONENTS IN DATASTAGE
  • Administrator Clint
  • 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

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

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

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
  • estartable

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

    Click here for Help and Support: info@sacrostectservices.com     For Inquiry Call Us:   +91 996-629-7972(IND)

  +91 996-629-7972(IND)
X

Quick Enquiry

X

Business Enquiry