DATA STAGE

DATA STAGE

Overview:
Data Stage is an integration tool, used in this space to perform the ETL for a data warehouse. It is essentially the data API into the warehouse. User Interface - usually a business intelligence reporting tool it uses a graphical notation to construct data integration solutions and is available in different versions such as the Server Edition, Enterprise Edition, and the MVS Edition.

Training Objectives of DATA STAGE:
This course gives you a clear understanding about how to use Data Stage. Even a non-programming and IT back ground can learn this Data Stage training. It supports the collection, transformation and integration of high volumes of data, with data structures ranging from simple to highly complex.

Target Students / Prerequisites:
Knowledge in computers and understanding about basic programs.

Course Contents:

Introduction about Data Stage
Difference between Server Jobs and Parallel Jobs
Difference between Pipeline Parallelisms
Partition techniques (Round Robin, Random, Hash, Entire, Same, Modules,Range,DB2,Auto)
Configuration File
Difference between SMP/MPD architecture
Data Stage Components (Server components/Client Components)
Package Installer

Data Stage Administrator
Creating project, Editing project and Deleting project
Permissions to user
.Apt Config file
Environment variable creation, permission

Data stage director
Introduction to Data stage Director
Job status View
View logs
Scheduling
Batches Creation

Designer
Introduction about Designer
Repository
Palatte
Types of Links
File Stages
Sequential File
Data set File
Lookup file set
Difference between Sequential file/Dataset/File set
Database stages
Dynamic RDBMS
Oracle Enterprise
ODBC Enterprise
Stored Procedure

Processing stages
Change Capture (Caption)
Compare stage
Difference Stage
Aggregate Stage
Transformer Stage
Surrogate Generator Stage
Join Generator Stage
Merge Generator Stage
Lookup Generator Stage
Difference between join/Lookup/Merge
Difference between join/Lookup
Remove Duplicates
Switch
Pivot
Modify
Funnel

Debugging stage
Head
Tail
Pea
Row Generator
Column Generator
Sample
Job Parameters

Manager
Introduction About Data stage Manager
Importing the Job
Exporting the Job
Importing Table Definition
Importing Flat File Definition
Routines

Containers
Difference between Local Container and Shared Container
Local Container
Shared Container

About the Trainer

10 + Years of IT experience, provided training for over 1000+ professionals online Real-time IT experience which enables to provide dedicated quality training. Teaching is his passion vast experience in providing online training around the globe with good communication skills.