Course #: 12015e - Data Stage Datawarehousing

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

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 Loding
•     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 imformation server
•     Web console for IBM imformation server

INTRODUCTION TO IBM WEB SPHERE DATASTAGE AND QUALITY STAGE 8X

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

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

Recommended Prerequisites:

• There are no mandatory prerequisites. Work experience in IT services is recommended.