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