Datastage Online Training

Introduction

IBM DataStage is among the top ETL tools for development and maintenance of Data Warehouses and Data Marts. DataStage provides complete group of choices to us to create solutions and provides access to the data and reports. It is an ideal resource for information integration projects – for example data marts, data warehouses and process migrations also. DataStage it has evolved over years and is indeed powerful. It can fill into any target and may get from any kind of supply, modify/cleanse information with its rich set of transformation capabilities. The change a part of ETL is all about receiving data cleaned, standard, and usually in to a format ideal for running into target. IBM DataStage integrates data on-demand across many systems using extended metadata management, a high-performance parallel framework, and business connectivity.

COURSE SUMMARY

Course Name Datastage Training
Course Contents Basics of Datastage, Its architecture and layout controls etc.
Course Duration 30 Hours with Flexible timings
Course Delivery Instructor Led-Live Online Training
Course Eligibility Any Graduate
Ideal For Freshers, aspirants seeking to learn the Datastage ETL Software
Next Batch Please visit the schedule section

Course Objectives

  • Basic Concepts of Data Stage and Administrator
  • Basic steps to deploy an ETL Project.
  • Execute difficult jobs debugging
  • Manage different databases
  • Implement real-time project

Course Curriculum

MODULE 1:  OVERVIEW OF THE DATA STAGE

  • Data Warehousing Introduction
  • Data Warehousing (What, Why, For Whom)
  • Data Warehousing Significance
  • Types of Systems (OLTP, DSS, OLAP)
  • Data Warehousing Life Cycle
  • Maintenance of Data Warehouse

MODULE 2:  DATA WAREHOUSING ARCHITECTURE

  • Source
  • Staging Area
  • Integration Layer
  • Target
  • Data Stage Introduction
  • Analysis & Reporting
  • IBM Information Sever architecture
  • Server Jobs and Parallel Jobs
  • Pipeline and Partition Parallelism
  • Configuration file
  • Partition techniques
  • SMP/MPP Architecture
  • Package installer
  • Data stage components

MODULE 3:  USING CONTROLS

  • Layouts
  • Project and Sandbox
  • Phase and Checkpoint
  • Sub graphs
  • Continuous Flows
  • Deadlocks
  • Interpreting the Log File
  • Wrapper Scripts
  • Monitoring the Graph
  • EME
  • Shop For Data (SFD)
  • Conduct>It
  • Data Profiler
Download Material

Write Review

Good

★★★☆☆
3 5 1
Thank you so much RAni for your efforts and quick help.. really appreciate.

Immensely Helpful.

★★★★★
5 5 1
Great course content, easy to comprehend, very good customer service !

Excellent Class Delivery

★★★★★
5 5 1
A very good course covering lots of topics. Excellent class delivery and lecture notes. I really learnt a lot and will surely miss not having the classes anymore. I will definitely keep in touch with IQ Online Training! I would also like to convey my special thanks to the IQ Online Training! The support team for their prompt technical support that is available 24/7 and for their awesome Learning.

Well Organised and Well Experienced

★★★★★
5 5 1
The instructor is well organised and well experienced; understand the pulse of audience very well and pays attention to detail - the way he paused between running commands to let the users first observe him and then try themselves indeed shows it. Hats off to him !

concise

★★★☆☆
3 5 1
The training is concise and it provides clarity on the subject.

More reviews...

Summary
Review Date
Reviewed Item
Datastage Online Training
Author Rating
5
Please follow and like us:

Testimonials

Write a Review

No review posted.