DATASTAGE REALTIME ONLINE TRAINING,CORPORATE TRAINING @APEX IN HYDERABAD

DATASTAGE HANDS-ON LIVE ONLINE TRAINING,CORPORATE TRAINING,INTERVIEW & JOB SUPPORT BY SOFTWARE WORKING PROFESSIONALS Interview Questions and Answers, Recorded Video Sessions, Materials, Mock Interviews Assignments Will be provided Course Curriculum (we can customize the course agenda as per your requirements) DATASTAGE 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