Session : 1 – Datastage Introduction
- DataStage Architecture
- DataStage Clients
- Designer
- Director
- Administrator
- DataStage Workflow
Session : 2 – Types of DataStage Job
- Parallel Jobs
- Server Jobs
- Job Sequences
Session : 3 – Setting up DataStage Environment
- DataStage Administrator Properties
- Defining Environment Variables
- Importing Table Definitions
Session : 4 – Creating Parallel Jobs
- Design a simple Parallel job in Designer
- Compile your job
- Run your job in Director
- View the job log
- Command Line Interface (dsjob)
Session : 5 – Accessing Sequential Data
- Sequential File stage
- Data Set stage
- Complex Flat File stage
- Create jobs that read from and write to sequential files
- Read from multiple files using file patterns
- Use multiple readers
- Null handling in Sequential File Stage
Session : 6 – Platform Architecture
- Describe parallel processing architecture Describe pipeline & partition parallelism
- List and describe partitioning and collecting algorithms
- Describe configuration files
- Explain OSH & Score
Session : 7 – Combining Data
- Combine data using the Lookup stage
- Combine data using merge stage
- Combine data using the Join stage
- Combine data using the Funnel stage
Session : 8 – Sorting and Aggregating Data
- Sort data using in-stage sorts and Sort stage
- Combine data using Aggregator stage
- Remove Duplicates stage
Session : 9 – Transforming Data
- Understand ways DataStage allows you to transform data
- Create column derivations using userdefined code and system functions
- Filter records based on business criteria
- Control data flow based on data conditions
Session : 10 – Repository Functions
- Perform a simple Find
- Perform an Advanced Find Perform an impact analysis
- Compare the differences between two Table Definitions and Jobs.
Session : 11 – Working with Relational Data
- Import Table Definitions for relational tables.
- Create Data Connections.
- Use Connector stages in a job.
- Use SQL Builder to define SQL Select statements.
- Use SQL Builder to define SQL Insert and Update statements.
- Use the DB2 Enterprise stage.
Session : 12 – Metadata in Parallel Framework:
- Explain schemas.
- Create schemas.
- Explain Runtime Column Propagation (RCP).
- Build a job that reads data from a sequential file using a schema.
- Build a shared container.
Session : 13 – Job Control
- Use the DataStage Job Sequencer to build a job that controls a sequence of jobs.
- Use Sequencer links and stages to control the sequence a set of jobs run in.
- Use Sequencer triggers and stages to control the conditions under which jobs run.
- Pass information in job parameters from the master controlling job to the controlled jobs.
- Define user variables.
- Enable restart.
- Handle errors and exceptions.
Thanks for the best ever Training. I did my Android Course here. Trainer is very good in knowledge. They provides the best ever Support to me.