DATASTAGE Training- 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
|
|
