Thank you for sending your enquiry! One of our team members will contact you shortly.
Thank you for sending your booking! One of our team members will contact you shortly.
Course Outline
Getting Started with DataStage
- The ETL process explained
- DataStage architectural overview
- Essential DataStage components
Managing DataStage
- Setup and configuration procedures
- Managing user access and security protocols
- Configuring projects and managing environments
- Scheduling and overseeing job execution
- Procedures for backup and disaster recovery
Extracting Data Efficiently
- Linking to diverse data sources
- Retrieving data from databases, flat files, and external interfaces
- Best practices for data extraction
Transforming Data using DataStage
- Navigating the DataStage designer interface
- Utilizing various stage types
- Embedding business logic into transformations
- Advanced techniques for data manipulation
Data Loading and System Integration
- Populating target systems with data
- Maintaining data accuracy and integrity
- Handling errors and generating logs
Optimizing Performance
- Strategies for performance enhancement
- Efficient resource allocation
- Managing job sequencing and parallel processing
Advanced Concepts
- Utilizing the DataStage director
- Troubleshooting and diagnostic methods
Recap and Future Directions
Requirements
- Foundational knowledge of database principles
- Proficiency in SQL and an understanding of data warehousing concepts
Target Audience
- IT Specialists
- Database Administrators
- Software Developers
35 Hours
Testimonials (2)
A journey through the Spark world: a very intense course. DSL, spark sql, partitioning vs bucketing for me.
Georgiana Elisabeta
Course - Apache Spark Fundamentals
Hands on exercises. Class should have been 5 days, but the 3 days helped to clear up a lot of questions that I had from working with NiFi already