Data Stage

Objective

This course provides detailed information about extracting, unifying and transforming data from various data sources (ETL process). Uniform data for reporting and analysis can be created trough Data Stage.

Audience

Modeller and developer

Prerequisites

A fundamental knowledge of databases (SQL) and dimensional data concepts

Content

Foundations of Data Warehousing and the role of Data Stage
Creating and administering catalogues
Connection to source and target data
Building and customizing the dimensional Framework
Creating builds to deliver data to a data mart
Create conformed dimensions
Aggregate, merge, and partition fact data
Automate functionality using JobStreams and commands
Resolve common data quality issues
Create business intelligence from data mart data