learnex

 
DATA STAGE
  • 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