2013-03-04

DATA STAGE
ONLINE TRAINING

Contents

·
Introduction about Data Stage

·
Difference between Server Jobs and Parallel Jobs

·
Difference between Pipeline Parallelisms

·
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

Data Stage
Administrator

·
Creating project, Editing project and Deleting project

·
Permissions to user

·
.Apt Config file

·
Environment variable creation, permission

Data stage director

·
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

·
Lookup file set

·
Difference between Sequential file/Dataset/File set

·
Database stages

·
Dynamic RDBMS

·
Oracle Enterprise

·
ODBC Enterprise

·
Stored Procedure

Processing stages

·
Change Capture (Caption)

·
Compare stage

·
Difference Stage

·
Aggregate Stage

·
Transformer Stage

·
Surrogate Generator Stage

·
Join Generator Stage

·
Merge 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

Show more