Note: This is Base Content and may change
based on requirements
Data Stage Course 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
The course is yet to be scheduled