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

for the course content please follow the link : http://ibasetraining.com/ibm-datastage-hands-on-online-training-job-support-from-india/