DATA STAGE
About This Course
Data Stage Training :
IBM DataStage is among the top ETL tools for development and maintenance of Data Warehouses and Data Marts. DataStage provides a 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 into a format ideal for running into a target. IBM DataStage integrates data on-demand across many systems using extended metadata management, a high-performance parallel framework, and business connectivity.
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 Server 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
- Subgraphs
- Continuous Flows
- Deadlocks
- Interpreting the Log File
- Wrapper Scripts
- Monitoring the Graph
- EME
- Shop For Data (SFD)
- Conduct>It
- Data Profiler