You are here: Home » Courses » Datawarehousing » DATASTAGE
DATASTAGE
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
Course: DATASTAGE
