Data Stage

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