iBase Training

Official Website

DataStage Online Training Course Content by Corporate Trainers

 

 

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 : info@ibasetraining.com

Phone/WhatsApp : +91-8106721223

USA Number : +1-650-993-1007

Gtalk : ibasetraining@gmail.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

 

 

Student Registration

Name

Email Id

Country Code

Mobile No

Course Name

City