Business Intelligence Training Overview
Learn how to build DataStage jobs that read and write to and from a variety of data store including sequential file,data sets,and relational tables. Also,learn how to build parallel jobs that process data in a variety of ways
What you will learn
- 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, filtering's, Sorting's and Aggregations
- Conduct searches and impact analyses
- Produce job reports
- Construct Database projects
- Working with the Datastage environment
Business Intelligence Audience
This is a basic course for those responsible for data Extraction And transformation using DataStage.
Business Intelligence Prerequisites
- Knowledge of UNIX or NT administration.
- Knowledge of TCP/IP and basic network principles.
- Data modeling experience.
- Familiarity with open Database(ODBC) and relation database
- access.
.
Business Intelligence Training Course duration
Five (5) Days Classroom & Lab Session
Business Intelligence Training Course outline
Day 1
DataStage Introduction and server Job
- Details of Datastage overview
Datastage Client Tools
- Designer
- Director
- Administrator
Datastage Server Job
- Transformer Stage
- Sort Stage
- Aggregator Stage
Lab Follows after every topic (Approx 30 Mins).
Day 2
Datastage Parallel Job
- File Stage:
- Sequential File Stage
- Data Set File Stage
- Database Stage.
- Oracle Enterprise Stage
- ODBC Stage
- Processing Stages
- Filter Stage
- Switch Stage
- Sort Stage
Lab Follows after every topic (Approx 30 Mins).
Day 3
- Transformer Stage
- Copy Stage
- Aggregator Stage
- Remove Duplicates Stage
- Funnel Stage
- Join Stage
Lab Follows after every topic (Approx 30 Mins).
Day 4
- Merge Stage.
- Lookup Stage (Simple & Range).
- Container.
- Local Container
- Shared Container
- Working With Parameters
- Job Parameters
- Parameters Sets
Lab Follows after every topic (Approx 30 Mins).
Day 5
- Change Capture.
- Change Apply.
- Job Sequence.
- Performance Tuning.
- Slowly Changing Dimensions(I,II,III) - Theoretical
- Job Sequence
- Deployment(Dev-->Test-->Prod)
Lab Follows after every topic (Approx 30 Mins).
