LiveZilla Live Help
India : +91 996 395 7366
USA : +1 214 347 4655

Data Stage

Data Stage Online Training

Course: Datastage 

Cognos Online training courses 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