Datastage Online Training

Spread the love

Datastage Online Training

Enrollmytraining provide Datastage online training by real time experts in IT industry .We provide Datastage  online Training in across the World like India,USA, UK, Singapore, UAE, Australia, Europe, Japan, South Africa,Malaysia, Dubai.

The student who had taken Datastage training got placed in top MNC’s .Student can select regular fast track and weekend batch .We provide Datastage online training at your comfortable timing from your home with flexible schedules.It is a Extraction Transfer Louding tool work database.

Data Warehouse Fundamentals

An introduction to Data Warehousing
Purpose of Data Warehouse
Data Warehouse Architecture
Operational Data Store
OLTP Vs Warehouse Applications
Data Marts Data marts Vs Data Warehouses
Data Warehouse Life cycle

Data Modeling

Introduction to Data Modeling
Entity Relationship model (E-R model)
Data Modeling for Data Warehouse
Dimensions and fact tables
Star Schema and Snowflake Schemas

ETL Design Process

Introduction to Extraction,
Transformation & Loading
Types of ETL Tools
Key tools in the market

Datastage Online Training course content

Data Stage Installation

Data stage Installation
Prerequisites to install Data stage
Installation process

Introduction to Data stage Version 8.1

Data stage introduction
IBM information Server architecture
Data Stage component
Data Stage main functions
Client components

Data stage Administrator

Data stage project Administration – Editing projects and Adding Projects
Deleting projects Cleansing up project files
Global variable setting – Environment management
Auto purging – Runtimes Column Propagation (RCP)
Add checkpoints for sequencer – NLS configuration
Generated OSH (Orchestra Engine) – System formats like data,
Timestamp – Project protect – Version details.

Data stage Director

Introduction to Data stage Director – Validating Data stage Jobs
Executing Data stage jobs – Job execution status
Monitoring a job – Job log view – job scheduling
Creating Batches – Scheduling batches

Data stage Designer

Introduction to Data stage Designer – Importance of Parallelism
Pipeline Parallelism – Partition Parallelism
Partitioning and collecting – Partition techniques
Data stage Repository Palette – Passive and Active stages
Job design overview – Designer work area
Annotations – Creating jobs – Importing flat file definitions
Dataset Overview

Working with Parallel Job Stages

Database Stages
Oracle – Teradata – ODBC – dynamic RDBMS

File Stages

Sequential file – Dataset – File set – Lookup file set

Processing Stages

Copy – Filter – Funnel – Sort Remove duplicate
Aggregator – Modify – Compress – Expand – Decode
Encode – Switch – Pivot stage – Lookup
Join – Merge – difference between look up,
Join and merge – change capture – Change apply
Compare – Difference – Surrogate key generator

Debug Stages

Head – Tail – Peek – Column generator
Row generator

Real Time Stages

XML input – XML output, Java packs,
Web service packs

Local and Shared containers

Advanced Stages in Parallel Jobs (Version 8.1)

Range Look process – Surrogate key generator stage
Slowly changing dimension stage – away stage
FTP stage – Java plug in – Job performance analysis
Resource estimation
Slowly Changing Dimensions implementation
Performance tuning

Job Sequencers

Arrange job activities in Sequencer
Triggers in Sequencer – Restablity
Recoverability – Notification activity
Terminator activity
Wait for file activity Start Look activity
Execute Command activity – Nested Condition activity
Exception handling activity – User Variable activity
End Loop activity – Adding Checkpoints

Datastage Online Training batch starts at weekend .You can enroll on your flexible timing