Courses Search

Datastage8 Online Training

 

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 Websphere Datastage & Quality Stage
• Parallel Processing
• Pipeline parallel processing
• Partition parallel processing
• Difference b/w Informatica & Data Stage
• Information Server Architectur

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

• SAP
• Microsoft Technologies
• Oracle Apps
• Testing tools
• Peoplesoft
• Data Warehouse
• Network/System Admin
• Databases
• Middleware Technologies
• Other Technologies