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