Phone : +1 (209)289-0289

Email id : contact@usitplacements.com

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.5×2 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