DATA STAGE ONLINE TRAINING

DATA-STAGE 8.0.1(Parallel Jobs)

 --------------------------------------

contents

 ---------------
 Introduction about Data Stage

Difference between Server Jobs and Parallel Jobs

Difference between Pipeline Parallelism and Partition Parallelism

Partition techniques(Round Robin,Random,Hash,Entire,Same,Modules,Range,DB2,Auto)

Configuration File

Difference between SMP/MPD Architecture

Data Stage components(server components/client Components)

Package Installer

Datastage Administrator

----------------------------

Creating project,Editing project and Deleting Project

Permissions to user

.APT config file

Environment variable creation,permission

Introduction to Data Stage Director

Job status View

View Logs

Scheduling

Batches Creation

Designer

---------------

Introduction about Designer

Repository

Palatte

Types of links

File Stages

Sequential File

Data set file

File Set

Look-up file set

Difference between Sequential file/Dataset/Fileset

Database Stages

Dynamic RDBMS

Oracle Enterprise

ODBC Enterprise

stored procedure

Processing Stage

--------------------

Change Capture(Caption)

Compare Stage

Difference Stage

Aggregate Stage

Transformer Stage

Surrogate Generator Stage

Lookup Generator Stage

Difference between Join/Lookup/Merge

Difference between Join/Lookup

Remove Duplicates

Switch

Pivot

Modify

Funnel

Debugging Stage

-------------------

Head

Tail

Pea

Row Generator

Column Generator

Sample

Job Parameters

Manager

--------

Introduction about Data stage Manager

Importing the job

Exporting the job

Importing Table Definition

Importing Flat File Definition

Routines

Containers

------------

Difference between Local Container and Shared Container

Local Container

Shared Container