BIGtheme.net http://bigtheme.net/ecommerce/opencart OpenCart Templates
Home / Data Stage 9.1 Online Training Course Topics

Data Stage 9.1 Online Training Course Topics

sub-banner960x200

Data Stage Online Training Course Topics


Duration
: 4 –  5 Weeks

 

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

STEP-7: INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

STEP-8: DATASTAGE DESIGNER

 

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

CONTAINERS

  •  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