Curriculum


• Data Warehouse Properties
• Data Warehouse Architecture
• ODS, Staging and Data Marts
• Schema and Types
• Dimensions and Facts

• DataStage jobs
• Creating massively parallel framework
• Scalable ETL features

• Data parallelism: Pipeline parallelism and Partitioning parallelism
• Data partitioning: Key-based partitioning and Keyless partitioning
• Partitioning techniques like round robin, entire, hash key, range, DB2 partitioning

• Data collecting techniques and types like round robin, order, sorted merge and same collecting methods

• DataStage Job
• Creating a Job that can effectively extract, transform and load data, cleansing and formatting data to improve its quality

• Parallel job stage editors
• Types of stage editors in DataStage
• Parallel Stages – Joins

• Working with the Sequential file stages

• Parallel Stages – Lookup, Merge, Differences between join Lookup and merge, Filter, Sort

• Aggregator Stage in DataStage
• Types of aggregation – Hash mode and Sort mode

• Transformer Stage in DataStage
• Characteristics - single input, any number of outputs and reject link
• Transformer Editor
• Evaluation sequence in this stage

• Deep dive into Transformer functions – String, type conversion, null handling, mathematical, utility functions
• Various features like constraint, system variables, conditional job aborting, Operators and Trigger Tab

• Describing configuration files
• Defining Environmental variables
• Defining Job level parameters
• Parameter sets

• Parameter Set
• Storing DataStage and Quality Stage job parameters
• Procedure to deploy Parameter Sets function and its advantages
• Learning about the various properties of Sequential File Stage and Dataset stage

• Parallel Stages – Funnel, Remove Duplicates
• Develop and Debug Stages – Peek, Row generator, Column generator, Sample
• Parallel Stages - Surrogate Key Generator and Pivot Enterprise Stage

• Local Containers
• Shared Containers

Training Options

Self-Paced Learning

19,999.00 14,999.00
  • Learn at your convenient time and pace
  • Gain on-the-job kind of learning experience through high quality Videos built by industry experts.
  • Interactive Sessions as good as Classroom experience.
  • Learn end to end course content that is similar to instructor led virtual/classroom training.
  • Cost Effective as well as Convenient.

Blended Learning

  • Everything in Self-Paced Plus
  • Learn in an instructor-led online training class

Corporate Training

Customized to your team’s needs

  • Customized learning delivery model (self-paced and/or instructor-led)
  • Flexible pricing options
  • Enterprise grade learning management system (LMS)
  • Enterprise dashboards for individuals and teams
  • 24×7 learner assistance and support

Course Description

IBM DataStage Training

DataStage is an ETL tool which extracts data, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. DataStage facilitates business analysis by providing quality data to help in gaining business intelligence. As part of this program, you will you learn DataStage data integration, ETL, data warehousing and work with data in rest or motion. As part of the training, you will work on real-life projects.

What you will Learn in this Course?

  • Introduction to Data Warehouse
  • DataStage Features
  • Concepts of Parallelism and Partitioning
  • Data Collecting Types and Techniques
  • DataStage Jobs
  • Stage Editor, Sequential File and Lookup File Set Stage
  • Processing Stages – Change Capture
  • Different Stages
  • Transformer Stage Functions & Features
  • Different Stages of Processing
  • Preparing for IBM Certified Solution Developer – Infosphere DataStage

Key Features

Self-Paced Online Video

• Self-paced Videos:24 Hrs
• Exercises & Project Work: 40 Hrs
• A 360-degree learning approach that you can adapt to your learning style

1 Year Unlimited Access

You get 1 Year unlimited access to LMS where presentations, quizzes, installation guide & class recordings are there.

24 x 7 Expert Support

We have 24x7 online support team to resolve all your technical queries, through ticket-based tracking system

Certification

Successfully complete your course and Tecklearn will provide you IBM DataStage Certification.

Real-life Case Studies

Live project based on any of the selected use cases, involving implementation of the various IBM DataStage concepts.

Learn at your Convenience

• Certification and Job Assistance
• Flexible Schedule

Reviews

N

Nagrajan K

IBM DataStage Training

Excellent support system friendly and cordial support team. Well organised content and detailed explanation in teaching.... Excellent support system friendly and cordial support team. Well organised content and detailed explanation in teaching. Read More
S

Surbhi Ajmera

IBM DataStage Training

I was working as a business analyst at TCS. The Tecklearn course taught me to think about the bigger picture. The learnings from this course have helped me enhance my performance at work and gain a mid-term increase in my salary.... I was working as a business analyst at TCS. The Tecklearn course taught me to think about the bigger picture. The learnings from this course have helped me enhance my performance at work and gain a mid-term increase in my salary. Read More
A

Ashish Sharma

IBM DataStage Training

Very good Hands-on DataStage Learning Experience. It was helpful with recorded sessions and detailed course curriculum. Covered each and every topic with real time scenarios. Thanks to Tecklearn Team.... Very good Hands-on DataStage Learning Experience. It was helpful with recorded sessions and detailed course curriculum. Covered each and every topic with real time scenarios. Thanks to Tecklearn Team. Read More
Z

Zeeshan Allam

IBM DataStage Training

Tecklearn is a great place for learning. I had an amazing learning experience. Especially their content and material is extremely good.... Tecklearn is a great place for learning. I had an amazing learning experience. Especially their content and material is extremely good. Read More
P

Piyush Poddar

IBM DataStage Training

Good Quality training with Real time experience trainers and hands on experience training.... Good Quality training with Real time experience trainers and hands on experience training. Read More

Certification

This training course is designed for clearing the IBM Certified Solution Developer – Infosphere DataStage exam. The entire course content is in line with the certification program and helps you clear the certification exam with ease and get the best jobs in top MNCs. As part of this training you will be working on real-time projects and assignments that have immense implications in the real-world industry scenarios, thus helping you fast track your career effortlessly.

Tecklearn’s IBM DataStage Certification will be awarded upon the completion of the course.

Projects

  • To put your knowledge on into action, you will be required to work on industry-based projects that discuss significant real-time use cases.
  • These projects are completely in-line with the modules mentioned in the curriculum and help you to clear the certification exam.

FAQ’s

FAQ Content


You will never miss a lecture at Tecklearn. Tecklearn provides recordings of each class so you can review them as needed before the next session.

Your access to the Support Team is for lifetime and will be available 24/7. The team will help you in resolving queries, during and after the course.

Post-enrolment, the LMS access will be instantly provided to you and will be available for lifetime. You will be able to access the complete set of previous class recordings, PPTs, PDFs, assignments. Moreover, the access to our 24x7 support team will be granted instantly as well. You can start learning right away.

Yes, the access to the course material will be available for lifetime once you have enrolled into the course.

DataStage is an ETL tool which extracts data, transform and load data from source to the target. The data sources might include sequential files, indexed files, relational databases, external data sources, archives, enterprise applications, etc. DataStage facilitates business analysis by providing quality data to help in gaining business intelligence.

All the instructors at Tecklearn are practitioners from the Industry with minimum 10-12 years of relevant IT experience. Each of them has gone through a rigorous selection process that includes profile screening, technical evaluation, and a training demo before they are certified to train for us. We also ensure that only those trainers with a high alumni rating remain on our faculty.

With online certification training you get the flexibility to learn on your own terms.
Major advantages are:
Access to Latest Course Curriculum
Connect with Instructors around the world
Real-life Projects & Case Studies
Lifetime Access & 24x7 support
ENROLL NOW
  • 19,999.00 14,999.00
  • 365 Days
  • Course Certificate
56 STUDENTS ENROLLED

Contact Us

Contact Us

Course Curriculum

Modules
IBM DataStage Mdoule -1 00:00:00
IBM DataStage Mdoule -2 00:00:00
IBM DataStage Module -3 00:00:00
IBM DataStage Module -4 00:00:00
IBM DataStage Module -5 00:00:00
IBM DataStage Module -6 00:00:00
IBM DataStage Module -7 00:00:00
IBM DataStage Module -8 00:00:00
IBM DataStage Module -9 00:00:00
IBM DataStage Module -10 00:00:00
IBM DataStage Module -11 00:00:00
IBM DataStage Module -12 00:00:00
IBM DataStage Module -13 00:00:00

Related Courses

TRENDING COURSES

X