DataStage Essentials for Mainframe

ExitCertified - Canada
Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg, Canada

Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced

Course Description:

'' Using the DataStage Mainframe edition, learn to build Extraction, Transformation, Load (ETL) jobs that run on the mainframe. These jobs extract data from a variety of native mainframe sources, including Common Business Oriented Language (COBOL) files, DB2 tables, Information Management System (IMS) databases, and Teradata databases. After transforming the data, these jobs can load the data into a variety of targets, including COBOL files, DB2 tables, Teradata tables, bulk loaders, and external routines.

Focus on how to design mainframe jobs in DataStage and how to generate the COBOL and Job Control Language (JCL) from these designs.

Also, learn how to perform a variety of data transformations and conversions using built-in DataStage functionality, including sorts, aggregations, joins, lookups and conditional lookups, filters, and derivations. Examine all the DataStage clients, including:

Administrator for configuring projects
Manager for managing metadata imported for use in DataStage jobs
Designer for designing DataStage jobs using Graphical User Interface (GUI) tools, generating the COBOL source, generating the JCL for compiling and running the job on the mainframe, and uploading the COBOL and JCL to the mainframe



...''

Phone:1.866.328.EXIT (3948)

School Address:

Ottawa, Ontario
ExitCertified Head Office
85 Albert Street, Suite 1200
Ottawa, Ontario, Canada
K1P 6A4

Toronto, Ontario
40 Eglinton Ave E., Suite 305
Toronto, Ontario, Canada
M4P 3A2

Montréal, Quebec
Sun Life Building
1155 Metcalfe Street, Suite 2120
Montréal, Québec, Canada
H3B 2V6

Québec City, Quebec
Holiday Inn Select
Centre-Ville
395, de la Couronne
Québec City, Québec, Canada
G1K 7X4

Vancouver, British Columbia
700 West Pender Street
Suite 610, Pender Place I
Vancouver, British Columbia, Canada
V6C 1G8

Calgary, Alberta
Suite 204
2333 - 18th Avenue NE
Calgary, Alberta, Canada
T2E 8T6

Edmonton, Alberta
10060 Jasper Ave.
Suite 810, Scotia Place
Edmonton, Alberta, Canada
T5J 3R8

Winnipeg, Manitoba
723 Portage Ave.
Winnipeg, Manitoba, Canada
R3G 0M8


Jobs & Resumes: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg
Houses & Roommates: Ottawa, Toronto, Vancouver, Calgary, Edmonton, Winnipeg

CICS Web Support Programming Workshop
CICS Transaction Server for z/OS Basic Tailoring
Data Warehouse
DB2 Federated Database Performance, Tuning, and Advanced Topics Workshop
WebSphere Information Integrator Federated Workshop
QMF/SQL for End Users
Relational Database
DB2 UDB Data Warehouse Edition Components with Cube Views
QMF on z/OS Workshop
Queue Replication
Hands on Technical Training for DS4000
AuditStage Essentials
DB2 UDB Advanced Programming
DB2 Fundamentals
DB2 SQL Workshop
DB2 Universal Database Administration Workshop for Linux
DB2 Universal Database Administration Workshop for UNIX
DB2 Universal Database Administration Workshop for Windows
IBM Informix Dynamic Server Advanced Performance Tuning

Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
 

Tips: Our combined search function does not only provide you with the training courses and students, but also talent resumes and jobs, or shared apartments nearby for rent.