Data Stage Course Content:

1.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

2.Data Stage Administrator

• Creating project, Editing project and Deleting project
• Permissions to user
• .Apt Config file
• Environment variable creation, permission

3.Data stage director

• Introduction to Data stage Director
• Job status View
• View logs
• Scheduling
• Batches Creation

4.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

5.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

6.Debugging stage

• Row Generator
• Column Generator
• Sample
• Job Parameters

7.Manager

• Introduction About Data stage Manager
• Importing the Job
• Exporting the Job
• Importing Table Definition
• Importing Flat File Definition
• Routines

8.Containers

• Difference between Local Container and Shared Container
• Local Container
• Shared Container