IBM InfoSphere DataStage is an ETL tool and part of the IBM Information Platforms Solutions suite and IBM InfoSphere. It uses a graphical notation to construct data integration solutions and is available in various versions such as the Server Edition, the Enterprise Edition, and the MVS Edition.
Duration: 30 – 35 hrs
Timings: Week days 1-2 Hours per day (or) Weekends: 2-3 Hours per day
Method: Online/Classroom Training
Study Material: Soft Copy
Understand the ETL concepts and How to solve the real time business problems.
Understand ETL Architecture and its various components.
IBM InfosphereDatastahe 9.1 - Course contents.
Datastage Introduction :
Types of DataStage Job
Setting up DataStage Environment
DataStage Administrator Properties
Defining Environment Variables
Importing Table Definitions
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)
Accessing Sequential Data
Sequential File stage
Data Set stage
Complex Flat File stage
Create jobs that read from and write to sequential files