DATASTAGE

MODULE 1 : DATA WAREHOUSE EVOLUTION

 TOPIC 1: DATA WAREHOUSE DEFINITIONS

 TOPIC 2: DATA WAREHOUSE EVOLUTION

 TOPIC 3: NEED FOR DATA WAREHOUSE & ITS ADVANTAGES

 MODULE 2 : DATA WAREHOUSE CONCEPTS

 TOPIC 1. OLTP, OLAP, ODS

 TOPIC 2. WHY OLAP FOR DATA WAREHOUSE

 TOPIC 3. OLTP TO OLAP TRANSFORMATION STEPS

 TOPIC 4. DIFFERENTIATE BETWEEN OLTP, OLAP, & DW

 TOPIC 5. DATA WAREHOUSE SYSTEM QUALIFIERS

 MODULE 3 : DATA WAREHOUSE ARCHITECTURE – PART 1 – GENERIC

 TOPIC 1. DATA WAREHOUSE GENERIC ARCHITECTURE

 TOPIC 2. DW COMPONENTS - TERMINOLOGY

 MODULE 4 : DATA MODELING IN DW-BI

 TOPIC 1. TYPES OF DATA MODEL IN DW-BI

 TOPIC 2. ER – RELATIONAL MODEL

 TOPIC 3. DIMENSIONAL MODEL

 MODULE 5 : DATA WAREHOUSE ARCHITECTURE – PART 2 – SPECIFIC

 TOPIC 1. DATA STORES – RESPONSIBILITIES IN DATA WAREHOUSE

 TOPIC 2. THE INMON DATA WAREHOUSE

 TOPIC 3. THE KIMBALL DATA WAREHOUSE

 TOPIC 4. THE INMON VERSUS KIMBALL DATA WAREHOUSE

 TOPIC 5. DATA WAREHOUSE – ARCHITECTURE TYPES

 TOPIC 6: DATA MINING – AN INTRODUCTION

 TOPIC 7: DATA GOVERNANCE – AN INTRODUCTION

 MODULE 01: INTRODUCTION

 LIST AND DESCRIBE THE USES OF DATASTAGE

 LIST AND DESCRIBE DATASTAGE CLIENTS

 DESCRIBE THE DATASTAGE WORKFLOW

 LIST AND COMPARE DIFFERENT TYPES OF DATASTAGE JOBS

 DESCRIBE TWO TYPES OF PARALLELISM EXHIBITED BY DATASTAGE PARALLEL JOBS

 MODULE 02: DEPLOYMENT

 IDENTIFY THE COMPONENTS OF INFORMATION SERVER THAT NEEDS TO BE INSTALLED

 DESCRIBE WHAT A DEPLOYMENT DOMAIN CONSISTS OF

 DESCRIBE DIFFERENT DOMAIN DEPLOYMENT OPTIONS

 DESCRIBE THE INSTALLATION PROCESS

 START THE INFORMATION SERVER

 MODULE 03: ADMINISTERING DATASTAGE

 OPEN THE ADMINISTRATIVE CONSOLE

 CREATE NEW USER AND GROUPS

 ASSIGN SUITE ROLES AND PRODUCT ROLES TO USERS AND GROUPS

 GIVE USER DATASTAGE CREDENTIALS

 LOG ON TO DATASTAGE ADMINISTRATOR

 ADD A DATASTAGE USER ON THE PERMISSIONS TAB AND SPECIFY THE USER’S ROLE

 SPECIFY DATASTAGE GLOBAL AND PROJECT DEFAULTS

 LIST AND DESCRIBE IMPORTANT ENVIRONMENT VARIABLES

 MODULE 04: DATASTAGE DESIGNER

 LOGON TO DATASTAGE

 NAVIGATE AROUND DATASTAGE DESIGNER

 IMPORT AND EXPORT DATASTAGE OBJECTS IN TO FILE

 IMPORT A TABLE DEFINITION FOR A SEQUENTIAL FILE

 MODULE 05: CREATING PARALLEL JOBS

 DESIGN A SIMPLE PARALLEL JOB IN DESIGNER

 DEFINE A JOB PARAMETER

 COMPILE YOUR JOB

 RUN YOUR JOB IN DIRECTOR

 VIEW THE JOB LOG

 MODULE 06: ACCESSING SEQUENTIAL DATA

 UNDERSTAND THE STAGES FOR ACCESSING DIFFERENT KINDS OF SEQUENTIAL DATA

 SEQUENTIAL FILE STAGE

 COMPLEX FLAT FILE STAGE

 CREATE JOBS THAT READ FROM AND WRITE TO SEQUENTIAL FILES

 CREATE REJECT LINK

 WORK WITH NULL’S IN SEQUENTIAL FILE

 READ FROM MULTIPLE FILES USING FILE PATTERNS

 USE MULTIPLE READERS

 MODULE 07: PLATFORM ARCHITECTURE

 DESCRIBE PARALLEL PROCESSING ARCHITECTURE

 DESCRIBE PIPELINE PARALLELISM

 DESCRIBE PARTITION PARALLELISM

 LIST AND DESCRIBE PARTITIONING AND COLLECTING ALGORITHMS

 DESCRIBE CONFIGURATION FILES

 DESCRIBE THE PARALLEL JOB COMPILATION PROCESS

 EXPLAIN OSH

 EXPLAIN THE SCORE

 MODULE 08: COMBINING DATA

 COMBINE DATA USING THE LOOKUP STAGE

 DEFINE RANGE LOOKUPS

 COMBINE DATA USING MERGE STAGE

 COMBINE DATA USING THE JOIN STAGE

 COMBINE DATA USING THE FUNNEL STAGE

 MODULE 09: SORTING AND AGGREGATING DATA

 SORT DATA USING IN-STAGE SORTS AND SORT STAGE

 COMBINE DATA USING AGGREGATOR STAGE

 COMBINE DATA REMOVE DUPLICATES STAGE

 MODULE 10: TRANSFORMING DATA

 USE THE TRANSFORMER STAGE IN PARALLEL JOBS

 DEFINE CONSTRAINTS

 DEFINE DERIVATIONS

 USE STAGE VARIABLES

 CREATE A PARAMETER SET AND USE ITS PARAMETERS IN CONSTRAINTS AND DERIVATIONS

 MODULE 11: REPOSITORY FUNCTIONS

 PERFORM A SIMPLE FIND

 PERFORM A ADVANCED FIND

 PERFORM IMPACT ANALYSIS

 COMPARE THE DIFFERENCE BETWEEN TWO TABLE DEFINITIONS

 COMPARE THE DIFFERENCES BETWEEN TWO JOBS

 MODULE 12: WORKING WITH RELATIONAL DATA

 IMPORT TABLE DEFINITIONS FOR RELATIONAL TABLES

 CREATE DATA CONNECTIONS

 USE CONNECTOR STAGES IN A JOB

 USE SQLBUILDER TO DEFINE SQL SELECT STATEMENTS

 USE SQLBUILDER TO DEFINE SQL INSERT AND UPDATE STATEMENTS

 USE DB2 ENTERPRISE STAGE

 MODULE 13: METADATA IN PARALLEL FRAMEWORK

 EXPLAIN SCHEMAS

 CREATE SCHEMAS

 EXPLAIN RUNTIME COLUMN PROPAGATION (RCP)

 TURN RCP ON AND OFF

 BUILD A JOB THAT READS DATA FROM A SEQUENTIAL FILE USING A SCHEMA

 BUILD A SHARED CONTAINER

 MODULE 14: JOB CONTROL

 USE THE DATASTAGE JOB SEQUENCER TO BUILD A JOB THAT CONTROLS A SEQUENCE OF JOBS

 USE SEQUENCER LINKS AND STAGES TO CONTROL SEQUENCE OF SET OF JOBS

 USE SEQUENCER TRIGGERS AND STAGES TO CONTROL THE CONDITIONS UNDER WHICH JOBS RUN

 PASS INFORMATION IN JOB PARAMETERS FROM MASTER CONTROLLING JOB TO THE CONTROLLED JOBS

 DEFINE USER VARIABLES

 ENABLE RESTART

 HANDLE ERRORS AND EXCEPTIONS