Duration
4 days
Prerequisites
You should have:
- Knowledge of the Windows OS
- Familiarity with Open Database Connectivity (ODBC) and relational database access technique
Objective
- Combine data using lookup, join, and merge stages
- Create jobs that read from and write to sequential files
- Make jobs that read from and write to a relational database using the connector stages
- Build jobs that process data using transformations, combinations, filterings, sortings and aggregations
- Conduct searches and impact analyses
- Produce job reports
- Construct DataStage users
- Administer the DataStage environment
Key Topics
- Deployment
- Administration console
- Designer
- Director
- Administrator
- Accessing sequential data
- Retrieve relational data using connectors
- Combining data
- Transforming data
- Repository
- Job control
- Metadata
- Parallel framework
- Complex Flat File stage
- Slowly Changing Dimensions
- MQ Connector
- Performance Analyzer and Resource Estimator utilities
Programme scope, delivery arrangements and suitability are confirmed during enquiry.