DATASTAGE

DATAWAREHOUSING CONCEPTS

  • History of Data warehouse
  • Need of a Data warehouse
  • OLTP Systems
  • Definition of Data warehouse
  • Difference b/w OLTP & DW
  • Datawarehousing Architecture
  • Data warehouse Vs. Data mart
  • Datawarehousing Approaches
  • Dimension Tables & Types
  • Slowly changing Dimension-Type1
  • Type 2 and Type 3
  • Conformed Dimension
  • Lately Arriving Dimension
  • Junk Dimension
  • Degenarated Dimension
  • Dirty Dimension
  • Fact Table & types
  • Measures & facts
  • Types of Facts
  • Datawarehousing Schemas
  • Data Acquisation Process
  • Project Life Cycle
  • Extraction types

WEBSPHERE DATASTAGE AND QUALITYSTAGE

  • Introduction to WebsphereDatastage& Quality Stage
  • Parallel Processing
  • Pipeline parallel processing
  • Partition parallel processing
  • Difference b/w Informatica& Data Stage
  • Information Server Architecture

WEBSPHERE DATASTAGE AND QUALITYSTAGE DESIGNER

  • Introduction to Datastage Designer
  • Metadata Repository
  • Palette
  • Genaral Stages
  • Data Quality
  • Investigate Stage
  • Match Frequency
  • MNS
  • Standardize Stage
  • Unduplicate Match
  • WAVES
  • Survive Stage
  • File Stages
  • Database Stages
  • Informix Stage
  • Classic Fedaration
  • IWay Enterprise
  • Netteza Enterprise
  • Development/Debug Stages
  • Processing Stages
  • FTP Stage
  • Transformer Stage
  • Slowly Changing Dimension Stage
  • Websphere TX Map
  • Real Time Stages
  • Web services Client
  • Web services Transformer
  • WISD Input
  • WISD Output
  • XML input
  • XML Output
  • XML Transformer
  • Websphere MQ
  • Java Client
  • Java Transformer
  • SAP Plug-In Stages
  • ABAP Stage
  • IDoc Extract Stage
  • IDoc Load Stage
  • BAPI Stage
  • Restrecture Stages
  • Buildop Stages
  • Exporting the DS Components
  • Importing the DS Components
  • Managing the Repository
  • Data Set Management Utility
  • Message Handler for Manager
  • Performance Analysis
  • Resource Estimation

WEBSPHERE DATASTAGE AND QUALITYSTAGE DIRECTOR

  • Introduction to Datastage Director
  • Validation of Data Stage Jobs
  • Run, Stop, Reset, Kill, and Unlock the DS Jobs
  • Scheduling the DS Jobs
  • Debugging
  • Saving Log into a File
  • Creation of Batch jobs
  • Monitoring the DS Jobs
  • View status, Job Log, Schedule Logs

WEBSPHERE DATASTAGE AND QUALITYSTAGE ADMINISTRATOR

  • Introduction to Administrator
  • Adding & Deleting a Project
  • Cleaning the Project Files
  • Changing & upgrading the license
  • Auto Purging
  • NLS Configuration
  • Share Metadata when importing connections
  • Protection of DS Projects
  • Set Environmental Variables
  • Set permissions to USERS
  • Enable RCP

WEBSPHERE INFORMATION ANALYZER

  • Data quality Assessment Methodology
  • IBM Websphere Information Analyzer Architecture
  • Column Analysis
  • Primary Key Analysis
  • Foreign Key Analysis
  • Cross Domain Analysis
  • Publish Analysis Results
  • IBM Websphere Audit Stage Business Rule Validation
  • Baseline Analysis
  • Reports
  • Migration of Datastage Jobs 7.5x2 to 8.0.1
  • Websphere Information Services Director (WISD)

JOB SEQUENCE

  • Intraduction to Sequencer
  • Arrange Job Activities in Sequencer
  • Triggers in Sequencer
  • Job Activity Stage
  • Notification Activity Stage
  • Wait-for-file Activity Stage
  • Routine Activity
  • Add Check Points
  • Terminate Activity
  • User Variable Activity
  • SCD IMPLIMENTATION
  • Performance Tunning in Parallel Jobs

 

Serjobs jobs
mapping sheet analysis
Unittesing docs
Deployment docs
Increment loading designing+SCD's+ Facttableloading .