ETL/ELT, buzz of Datawarehouse, Initial point and source for Reporting and Analytics, IBM Datastage is always in demand ETL tool used in many sectors to implement Business Requirement.
There are detailed explanation on the Architecture, Installation, Topology & 65 examples of Job Design using different stages to learn Datastage Designer and Director. Additionally, the course is filled with assignments & scenarios with free-data for practice.
Let's parse that.
IBM Datastage is one of the software in IBM Inforsphere Information Server Suite and is used in all major sectors not limited to Banking, HealthCare, LifeScience, Aerospace projects for data transformation and cleaning.
Because of its cool User Interface and ease of design, its easy to implement any requirement/scenario with limited background knowledge.
These 65 examples will help you trust Datastage. Each is self-contained, has its dsx code attached. Each example is simple, but not simplistic.
The Big Ideas: Before we get to the how, we better understand the why - this course will help clarify why we even need ETL and Datastage.
The Little Details That Matter: Partitioning & Pipelining, Types of Jobs(Server,Parallel & Sequencer Jobs) and their differences, Deployment topologies (like Two tier, three Tier, Cluster & Grid). Concepts like these matter, this course will cover them.
Aditionally, the course focus on live requirement implementation & clarifications. Hence, we design 65 scenarios to understand the basic concepts of stages from Designer & Project setup from Web Console and Administrator.
Also, you are provided with Datastage 9.1 and Datastage 11.3 Virtual Machine where you can practice and explore the tool.
Using discussion forums
Please use the discussion forums on this course to engage with other students and to help each other out. Unfortunately, much as we would like to, it is not possible for me to respond to individual questions from students:-(
I have worked with many consultancies on training Datastage and have literally seen students getting looted by them, in terms of money, time and training content and quality. And hence,I took over my course to Udemy to make it reachable to millions at an affordable price without worrying about the mediators.
Also, I have implemented the entire experience of 3 years of training to create a course, which is self understandable and covers all the concepts required to implement any simple to complex scenario on Datastage. And hence, the course comes with *MINIMAL Technical support over email or in-person*. The truth is, direct support is hugely expensive and just does not scale.
We understand that this is not ideal and that a lot of students might benefit from this additional support. Hiring resources for additional support would make our offering much more expensive, thus defeating our original purpose of delivering the course at a low cost. But we can definately use the discussion forum to help each other out. I can pitch in at times on certain scenarios if required.
It is a hard trade-off.
Thank you for your patience and understanding!
What are the requirements?
Basic knowledge of DB concepts like Joins (Left, Outer, Inner or Full) & Slowly Changing Dimension Concepts esp SCD Type 1 & 2.
The course cover the Virtual Machine set up of Datastage - no worries on that front as we have to simply use the Virtual Machine & Datastage is installed already!
What am I going to get from this course?
The course explains the basic concepts and architecture of Datastage, sets the mandatory steps to follow to design the jobs to ensure minimal errors and warnings, use Datastage to Implement Business requirement using different stages, pick up the correct stage to create a best suitable job.
Identify what features are available in the stages that we can choose to implement a certain requirement to ensure limited stage usage and maximum output with accuracy.
Lastly, I would like to thank my colleague "Sushmita Gaur" in helping me create this Video. Your input and guidance are very helpful in putting things together.