Courses » Datawarehouse Online Training » DataStage8 Online Training

 

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