Search this site

    SAP ONLINE TRAINING

    DataStage Online Training


    Datastage Online Training


    DataStage Course Content:
    • Introduction to DATASTAGE
    • What is datastage?
    • Difference between server jobs and parallel jobs
    • Difference between pipeline parallelism and partition parallelism
    • Partition techniques (round robin, random, hash, entire, same, modules, range, DB2, auto)
    • Collecting Techniques (Auto, sortmerge, ordered)
    • Configuration file
    • Difference between SMP/MPP architecture
    • Data stage components (server components/client components)
    • Package installer
    • DATASTAGE ADMINISTRATOR
    • Create Project
    • Delete Project
    • Protect Project
    • Environmental variables
    • Auto purge
    • RCP
    • OSH
    • Commands Execute
    • Multiple Instances
    • Job Sequence Settings
    • Data stage director:
    • Introduction to data stage director
    • Job status view
    • View logs
    • Scheduling
    • Batches creation
    • Data stage Designer:
    • About Web Sphere DataStage Designer
    • Partitioning Methods
    • Partitioning Techniques
    • Designer Canvas
    • Central Storage
    • Job Designing
    • Creating the Jobs
    • Compiling and Run the Jobs
    • Exporting and importing the jobs
    • Parameter passing
    • System(SMP) & Cluster system(MPP)
    • Importing Method(Flat file, Txt, Xls and Database files)
    • OSHImporting Method
    • Configuration file
    • Processing stage:
    • Aggregator
    • Change apply
    • Change capture
    • Compare
    • Compress
    • Copy
    • Decode
    • Difference
    • Encode
    • Expand
    • External filter
    • Filter
    • FTP
    • Funnel
    • Generic
    • Join
    • Lookup
    • Merge
    • Difference between join/lookup
    • Difference between join/lookup/merge
    • Modify
    • Pivot
    • Remove duplicates
    • Slowly changing dimension
    • Sort
    • Surrogate key generator
    • Switch
    • Transformer
    • Websphere TX Map
    • Transformer stage
    • Surrogate generator stage
    • Join generator stage
    • Merge generator stage
    • Look up generator stage
    • Debugging stage
    • Head
    • Tail
    • Peak
    • Row generator
    • Column generator
    • Sample
    • Job parameters
    • PARAMETER SETS
    • SLOWLY CHAMGING DIMENSIONS
    • Sequencer
    • Importing the job
    • Exporting the job
    • Importing table definition
    • Importing flat file definition
    • Containers
    • Difference between local container and shared container
    • Local container
    • Shared container