DATA STAGE ONLINE TRAINING

                                 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