> Formations > IBM InfoSphere DataStage Essentials (v11.5)
Publication date : 01/03/2024
Course : IBM InfoSphere DataStage Essentials (v11.5)Implementing an ETL project
Practical course - 4d
- 28h00 - Ref. TD2
|
Download in PDF format
Share this course by email
 | Describing the uses of DataStage and DataStage Workflow |
| Describe Information Server architecture and how DataStage integrates with it |
| Describe Information Server and DataStage deployment options |
| Use the Information Server web console and DataStage administration client to create users |
| Import and export DataStage objects to a file |
| Import table definitions for sequential files and relational tables |
| Design, compile, activate and monitor parallel jobs in DataStage |
| Design jobs that read and write sequential files |
| Describe DataStage's parallel processing architecture |
| Design jobs that combine data with joins and searches |
| Design jobs that sort and group data |
| Implement complex business logic with DataStage Transformer |
| Debugging DataStage tasks with DataStage PX Debugger |
| Setting up the DataStage environment |
Intended audience
Administrateurs de projet et développeurs ETL responsables de l'extraction et de la transformation des données à l'aide de DataStage.
Prerequisites
Basic knowledge of the Windows operating system and database access techniques.
Certification
Official course without certification.
Comment passer votre examen ?
Comment passer votre examen ?
Practical details
Teaching methods
Training in French. Official course material in digital format and in English. Good understanding of written English.
Course schedule
1 Module 1: Introduction to DataStage
2 Module 2: Deploying DataStage
3 Module 3: DataStage administration
4 Module 4: Working with metadata
5 Module 5: Creating parallel tasks
6 Module 6: Accessing sequential data
7 Module 7: Partitioning and collecting
8 Module 8: Combining data
9 Module 9: Group treatment steps
10 Module 10: Transformation stage
11 Module 11: Repository functions
12 Module 12: Working with relational data
13 Module 13: Controlling tasks
PARTICIPANTS
Administrateurs de projet et développeurs ETL responsables de l'extraction et de la transformation des données à l'aide de DataStage.
PREREQUISITES
Basic knowledge of the Windows operating system and database access techniques.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Administrateurs de projet et développeurs ETL responsables de l'extraction et de la transformation des données à l'aide de DataStage.
PREREQUISITES
Basic knowledge of the Windows operating system and database access techniques.
TRAINER QUALIFICATIONS
The experts who lead the training courses are specialists in the subjects covered. They are approved by the publisher and certified for the course. They have also been validated by our teaching teams in terms of both professional knowledge and teaching skills for each course they teach. They have at least three to ten years of experience in their field and hold or have held positions of responsibility in companies.
ASSESSMENT TERMS
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
Assessment of targeted skills prior to training.
Assessment by the participant, at the end of the training course, of the skills acquired during the training course.
Validation by the trainer of the participant's learning outcomes, specifying the tools used: multiple-choice questions, role-playing exercises, etc.
At the end of each training course, ITTCERT provides participants with a course evaluation questionnaire, which is then analysed by our teaching teams. Participants also complete an official evaluation of the publisher.
An attendance sheet for each half-day of attendance is provided at the end of the training course, along with a certificate of completion if the participant has attended the entire session.
TEACHING AIDS AND TECHNICAL RESOURCES
The teaching resources used are the publisher's official materials and practical exercises.
The teaching resources used are the publisher's official materials and practical exercises.
TERMS AND DEADLINES
Registration must be completed 24 hours before the start of the training course.
ACCESSIBILITY FOR PEOPLE WITH DISABILITIES
Do you have specific accessibility requirements? Contact Ms FOSSE, disability advisor, at the following address: psh-accueil@orsys.fr so that we can assess your request and its feasibility.
Dates and locations
Select your location or opt for the remote class then choose your date.
Remote class
Dernières places
Date garantie en présentiel ou à distance
Session garantie