Moyens d'évaluation :
- Quiz pré-formation de vérification des connaissances (si applicable)
- Évaluations formatives pendant la formation, à travers les travaux pratiques réalisés sur les labs à l’issue de chaque module, QCM, mises en situation…
- Complétion par chaque participant d’un questionnaire et/ou questionnaire de positionnement en amont et à l’issue de la formation pour validation de l’acquisition des compétences
A qui s'adresse cette formation
Project administrators and ETL developers responsible for data extraction and transformation using DataStage.
Pré-requis
- Basic knowledge of Windows operating system
- Familiarity with database access techniques
Contenu
This course enables the project administrators and ETL developers to acquire the skills necessary to develop parallel jobs in DataStage. The emphasis is on developers. Only administrative functions that are relevant to DataStage developers are fully discussed. Students will learn to create parallel jobs that access sequential and relational data and combine and transform the data using functions and other job components.
- 1. Introduction to DataStage
- 2. Deployment
- 3. DataStage Administration
- 4. Work with Metadata
- 5. Create Parallel Jobs
- 6. Access Sequential Data
- 7. Partitioning and Collecting Algorithms
- 8. Combine Data
- 9. Group Processing Stages
- 10. Transformer Stage
- 11. Repository Functions
- 12. Work with Relational Data
- 13. Control Jobs
Moyens Pédagogiques :