Hayagriva Technologies
Data stage Course Content
www.hayagrivatechnologies.com
Introduction to Data stage
· Introduction about Data Stage
•
IBM Information Sever architecture
•
Datastage within the IBM Information Sever architecture
•
Difference between Server Jobs and Parallel Jobs
•
Difference between Pipeline Parallelism and Partition Paralleli
sm
•
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
Datastage Administrator
•
Creating project, Editing project and Deleting project
•
Permissions to user
•
.APT config file
•
Environment variable creation, permission
Datastage Director
•
Introduction to Data stage Director
•
Job Status View
•
View logs
•
Scheduling
•
Batches Creation
Designer
•
Introduction about Designer
•
Repository
•
Palatte
Hayagriva Technologies
Data stage Course Content
www.hayagrivatechnologies.com
•
Type of Links
•
File Stages
•
Sequential file
•
Dataset file
•
File set
•
Lookup file set
•
Difference between Sequential file/Dataset/File set
•
Database stages
§
Dynamic RDBMS
§
Oracle Enterprise
§
ODBC Enterprise
§
Stored Procedure
Processing stage
•
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
Hayagriva Technologies
Data stage Course Content
www.hayagrivatechnologies.com
Debugging Stage
•
Head
•
Tail
•
Pea
•
Row Generator
•
Column Generator
•
Sample
•
Job Parameters
Manager
•
Introduction about Datastage 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
Job sequencer
•
Arrange job activities in sequencer
•
Triggers in Sequencer
•
Restability
•
Recoverability
•
Notification activity
•
Terminator Activity
Hayagriva Technologies
Data stage Course Content
www.hayagrivatechnologies.com
•
Wait for file activity
•
Start look activity
•
Execute command activity
•
Nested Condition activity
•
Routine activity
•
Exception handing activity
•
User variable activity
•
End loop activity
•
Adding Checkpoints
Information Analyzer
•
IBM Websphere Information Analyzer overview
•
Data profiling process
•
Column
•
Analysis
•
Primary key analysis
•
Foreign key analysis
•
Cross-domain analysis
•
Baseline analysis
•
Analysis result publication
•
Deleting analysis results
•
Reports for information analysisC
•
Column analysis summary statistics reports
•
Baseline analysis reports
•
Cross-domain analysis reports
•
Primary key reports
•
Foreign key analysis reports
http://www.hayagrivatechnologies.com/Datastage.pdf
-------------------------------------or----------------------------------------
DATA STAGE Training
Course Content
DW and ETL
Concepts
·
DW Overview
·
Data Consolidation and Integratiion
·
ETL Lifecycle
·
Data cleaning and conforming
Information Server components
·
Fast track
·
Metadata
workbench
·
Business
Glossary
·
Information
Analyzer
·
Information
Services Director
·
Blueprint
Director
·
Deployment tool
Web Console Administration
·
Managing users and groups
·
Managing user credentials
Datastage Administrator
·
Project Administration
·
Setting Environment Variables
·
Managing Logs
·
Enabling RCP
·
User Roles and Permissions
·
Lab Exercises
Datastage
Architecture
·
Design time architecture
·
Run time architecture
·
Partition and pipeline parallelism
Server Jobs
- Server Vs Parallel jobs
- Can I convert Server jobs to Parallel Jobs?
- Architectural differences
- Different stages
- BASIC Programming
- Containers
Datastage
Director
·
Director User Interface
·
Compiling single and multiple jobs
·
Validate , Run ,Reset , Restart jobs
·
Scheduling Jobs
·
Checking logs
·
Performance monitor on designer
·
Logs for sequence jobs
Importing Metadata
·
Sequential file metadata imports
·
Schemas
·
Direct import from database
·
Importing Shared metadata
·
Lab Exercises
Handling files
·
Sequential filestage
·
Complex flat file stage
·
File formats
·
Managing huge files
·
Performance considerations
·
Rejecting invlaid data
·
Lab Exercises
Parallel Job Stages
- File stages
- Database stages
- Processing stages
- Debug stages
- Sequence job stages
- Pivot stage
- SCD Stage
Handling input data
- Processing file based data
- Handling relational input data
- Processing incremental data
- Staging area
- Lab Exercises
Environment variables
- Understaning the environment variables
- Parallel
- Buffering
- Reporting
- Monitoring
- Database specific
End to end ETL developmenmt
task – Case study
Troubleshooting
Performance enhancements
Best Practices
http://www.apex-online-it-training.com/Courses/data%20stage-online-training-from-india-by-real%20time-expert.php
No comments:
Post a Comment