Datastage

DATASTAGE PARALLEL JOBS

DATA WAREHOUSING CONCEPTS

History of Data Warehousing

· Need of a Datawarehousing

· OLTP Systems

· Definition of a Data Warehouse

· Difference b/w OLTP & DW

· Data warehouse Architecture

· Data Warehouse vs. Data Mart

· Data warehousing Approaches

· Design of a Datawarehousing

· Dimension table & types

· Slowly Changing Dimensions-Type 1,

Type 2 and Type 3

· Confirmed Dimension

· Junk Dimension

· Degenerate Dimension

· Dirty Dimension

· Fact Table & types

· Measure and Fact

· Types of Facts

· Data warehousing Schemas( Star, Snowflake)

· Data Acquisition process

· Project Life Cycle

DATASTAGE

· Introduction to Data stage

· Parallel Processing

· Pipeline Parallelism

· Partition Parallelism

· Client and Server Components

Data Stage Designer

· Introduction to Data Stage Designer

· Repository

· Palette

· General Stages

· Sequential File

· Data Set

· File Set

· Lookup File Set

· Complex Flat File

· DB2 /UDB Enterprise

· Oracle Enterprise

· Teradata Enterprise

· Dynamic RDBMS

· Copy and Modify

· Transformer

· Aggregator

· Join, Merge, Lookup

· Sort

· Funnel

· Remove Duplicates

· Filter

· Change Capture

· Change Apply

· Surrogate Key

· Head, Tail, Sample and Peek

· Row Generator and Column Generator

· Pivot

· ODBC Stage

· Filter & switch

· Funnel

· Difference

· Compare

Data Stage Director

· Introduction to Director

· Validating Jobs

· Running, Stopping, Resetting Jobs

· Restarting Job Sequences

· Scheduling Jobs and Sequences

· Debugging

· Cleanup Job Resources

· Clearing Job Status File

· Saving Job Log into a file

· Creating, Running, Scheduling a Job Batch

· Monitoring Jobs

· View Status,Schedule,Log

Data Stage Manager

· Introduction to Manager

· Importing Data stage components

· Exporting Data stage components

· Message Handling

· Routines

· Configuration File

· Adding, Deleting and Moving Projects

· Limiting Access to Projects

· Data Set Management

Data Stage Administrator

· Introduction to Administrator

· Adding & Deleting project

· Cleaning up Project files

· Changing & Upgrading licenses

· Auto purging

· Permissions to Users

· NLS Configuration

· RCP

· Enable Remote execution of Parallel Jobs

· Add Environmental Variables

Job Sequencer

· Introduction to Sequencer

· Arrange job activities in Sequencer

· Triggers in sequencer

· Job Activity

· Notification Activity

· Wait- for- file Activity

· Routine Activity

· Add Check points

· Terminator Activity

· User Variable Activity

· SCD Implementations

· Performance Tuning in parallel Jobs

· Data Stage Server Jobs

OUR Additional Features

v Interview Questions

v Real Time Scenarios

v Resume Preparation

v Real Time Project