DATASTAGE Online Training

• admin
• 9 years ago
• Categories: Datawarehousing Online Training & Placements on VelocityInfo

DATASTAGE Online Training

DATASTAGE Online Training Course Content :

DATA WAREHOUSING CONCEPTS

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

WEBSPHERE DATA STAGE AND QUALITY STAGE

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

WEBSPHERE DATA STAGE AND QUALITY STAGE DESIGNER

• Introduction to Data stage Designer
• Metadata Repository
• Palette
• General Stages
• Data Quality
• Investigate Stage
• Match Frequency
• MNS
• Standardize Stage
• Unduplicate Match
• WAVES
• Survive Stage
• File Stages
• Database Stages
• Informix Stage
• Classic Federation
• 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 DATA STAGE AND QUALITY STAGE DIRECTOR

• Introduction to Data stage 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 DATA STAGE AND QUALITY STAGE 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 Web sphere Information Analyzer Architecture
• Column Analysis
• Primary Key Analysis
• Foreign Key Analysis
• Cross Domain Analysis
• Publish Analysis Results
• IBM Web sphere Audit Stage Business Rule Validation
• Baseline Analysis
• Reports
• Migration of Data stage Jobs 7×2 to 8.0.1
• Webs phere Information Services Director (WISD)

JOB SEQUENCE

• Introduction 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 + Facttable loading.