Crash course on IBM Datastage

Working with Datastage Client components

What you’ll learn
Fundamentals of ETL
Dimension, Fact and Schema
Architecture of Datastage
Types of Datastage jobs
History of Datastage
Datastage jobs and its Stages
Requirements
Concepts of ETL
Basics of Datawahousing
Description
This Course details on knowledge about IBM Datastage Designer and Director Client components. In this course, we have demonstrated each and every step that the developer can follow to create their Own IBM Datastage jobs, Compile them and Run them. The videos captures every working action the developer needs to do while accessing different features of each Components. Any Beginner or Fresher interested in learning IBM Datastage fundamentals can have clear understanding and work on Hands-on situations shared at the end of the session.
This course explains why IBM Datastage is better ETL tool in Market and about various Partitioning methods, most commonly used Stages to create Jobs. This course also explains the Fundamentals of Dataware housing concepts. End of this course, the student will have maximum comfort with with Datastage as a Developer. With 15+ years of experience we have broken the sessions as small videos which can be taken during any leisure time available for the Students and Beginners. If any session in the course needs to be elaborated, please leave a comment and I will get back with updated video DEMO explaining those topics in detail. Enroll them and start your Carrier as Datastage ETL Developer. Thank you.

Overview

Section 1: Working with Datastage Designer

Lecture 1 Datastage – Client Components

Lecture 2 Designer – Look & Feel

Lecture 3 Types of Jobs

Lecture 4 Designer Palette

Lecture 5 My First Parallel job

Section 2: Datastage Director

Lecture 6 Datastage Director

Section 3: Theory – ETL & Datastage Partitioning

Lecture 7 What is ETL?

Lecture 8 Dimension, Fact and Schema

Lecture 9 Datastage -Type of Partitioning

Section 4: Designer Palette

Lecture 10 Sequential File & Dataset

Lecture 11 Copy

Lecture 12 Filter

Lecture 13 Sort Stage

Lecture 14 Remove Duplicate Stage

Lecture 15 Aggregator Stage

Lecture 16 Switch Stage

Lecture 17 Column Generator Stage

Lecture 18 Row Generator Stage

Lecture 19 Sample Stage

Lecture 20 Funnel

Lecture 21 Head Stage

Lecture 22 Tail Stage

Lecture 23 Peek Stage

Lecture 24 Transformer Stage

Lecture 25 Join Stage

Lecture 26 Merge Stage

Lecture 27 Lookup Stage

Section 5: Conclusion

Lecture 28 Scenarios to work

Lecture 29 Summary

Software Professionals,College Graduates,Beginners in ETL tools/Datastage