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