IBM Datastage hands on Online Corporate Training Job Support

IBM Datastage realtime online training, job & interview support by hands-on Professionals

DataStage Training Experience the real time implementation of datastage projects by exploring data warehouse life cycle, data modeling for data warehouse, project administration, IBM DataStage ETL tool, Fact and Schema; Architecture of Datastage, FTP stage, graphical front-end to designing., etc.

FOR FREE DEMO contact :
Email : [email protected]
Phone/WhatsApp : +91-(850) 012-2107
USA Number : 214-628-3894
Gtalk : [email protected]
Blog: http://apex-it-online-trainings.blogspot.in
Website: www.apex-online-it-trainings.com

DataStage Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided

DATASTAGE COURSE CURRICULUM
(the course content can be modified as per your requirements):

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

Data quality