• Data Warehouse Definition
• OLTP vs OLAP
• Data Warehouse Process Overview
• Staging Area
• Datamart

• Star schema
• Snowflake schema
• Fact constellations

• E/R modeling
• Dimensional modeling

• Datastage Server
• Datastage Parallel Extender
• Comparison between Datastage Server Vs Parallel

• DataStage Architecture
• DataStage Clients
  • Designer
  • Director
  • Administrator

• Parallel Jobs
• Server Jobs
• Job Sequence

• DataStage Administrator Properties
• Defining Environment Variables
• Importing Table Definitions

• Design a simple Parallel job in Designer
• Compile your job
• Run your job in Director
• View the job log
• Command Line Interface (dsjob)

• Sequential File stage
• Data Set 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

• Describe parallel processing architecture Describe pipeline &
• Partition parallelism
• List and describe partitioning and collecting algorithms
• Describe configuration files
• Explain OSH & Score

• Sort data using in-stage sorts and Sort stage
• Combine data using Aggregator stage
• Remove Duplicates stage

• Combine data using the Lookup stage
• Combine data using merge stage
• Combine data using the Join stage
• Combine data using the Funnel stage

• Understand ways DataStage allows you to transform data
• Create column derivations using user defined code and system functions
• Filter records based on business criteria
• Control data flow based on data conditions

• Import Table Definitions for relational tables.
• Create Data Connections.
• Use SQL Builder to define SQL Select statements.
• Use SQL Builder to define SQL Insert and Update statements.
• Use the DB2 Enterprise stage.

• Explain schemas.
• Create schemas.
• Explain Runtime Column Propagation (RCP).
• Build a job that reads data from a sequential file using a schema

• Checkpoint/Restart
• Looping
• Expression Support
• User Variables Stage
• Automatically Handling Aborts
• Terminator Stage ~ aborting a sequence
• Enhanced Variable Support
• Enhancements to other activity stages

• Standards
• Development guidelines
• Component usage
• DataStage Data Types
• Partitioning data
• Collecting data
• Sorting
• Stage specific guidelines

Yes, you get two kinds of discounts. They are group discount and referral discount. Group discount is offered when you join as a group, and referral discount is offered when you are referred from someone who has already enrolled in our training.

The trainer will give Server Access to the course seekers, and we make sure you acquire practical hands-on training by providing you with every utility that is needed for your understanding of the course.

The trainer is a certified consultant and has significant amount of experience in working with the technology.

Yes, we accept payments in two installments.

If you are enrolled in classes and/or have paid fees, but want to cancel the registration for certain reason, it can be attained within first 2 sessions of the training. Please make a note that refunds will be processed within 30 days of prior request.