DataStage real time online training from apex

FOR FREE DEMO contact :

Email : [email protected]

Phone/WhatsApp : +91-(850) 012-2107

USA Number : 214-628-3894

Gtalk : [email protected]

Blog: https://best-online-it-training-institute.blogspot.com

Data
Stage 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



Copyright 2018 Apex Online IT Trainings Inc. All Rights Reserved

Call us on : USA - +1 214 628 3894 | IND - +91 8500122107

for your course please follow the link : https://www.apex-online-it-trainings.com/it-trainings-at-ape
x/datastage-online-training-by-realtime-experts