DATA STAGE ONLINE TRAINING

DATA STAGE ONLINE TRAINING

DATASTAGE ONLINE TRAINING BY REAL TIME EXPERTS

FRESH BATCH STARTING FROM NEXT WEEK

 

FOR FREE DEMO contact us at:

EMail:    raj@apex-online-it-training.com
Phone:    +91-850-012-2107--------------------------
WORKS 24/7

Phone : 001-9722209571 -------------------------------- USA FREE LAND PHONE
WebSite: www.apex-online-it-training.com

USA LAND PHONE ---6AM TO 9AM AND 6PM T0 11PM IST(INDIAN TIMINGS )

 




ABOUT THE TRAINER

  • 11 YEARS OF INDUSTRY EXPERIENCE
  • 5 YEARS OF EXPERIENCE IN ONLINE AND CLASSROOM TRAINING



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

 

Data quality