| Datastage online Training|Comprehensive Training by Experts | | Print | |
|
DW and ETL Concepts: DW Concepts What is Data warehouse? Components of Data warehouse Decision support systems OLTP Systems OLTP vs DATA WAREHOUSE Data Mart Difference between Data warehouse and Data Mart Data quality Meta data ETL Design ETL Tools Comparison
Overview of Information Server : Different components of Informaton Server Datastage and Quality stage Fasttrack Metadata workbench Information Analyzer Business Glossary
Web Console Administration: Managing user credentials Managing users and groups Lab Exercises
Datastage Director : Director User Interface Compiling single and multiple jobs Validate , Run ,Reset , Restart jobs Setting Job Parameters Scheduling Jobs Checking logs Performance monitor on designer Job sequencer
Administrator:
Project Administration Setting Env Variables Managing Logs Enabling RCP User Roles and Permissions Lab Exercises Test
Designer : Simple server job Understanding the Generic User Interface Tool bars, Pages, Tabs Projects , Jobs Creating a new job Compiling a job Simple server job Simple parallel job Sequential and parallel jobs Parallel Processing Pipeline and Partition Parallelism Partition Difference between server and parallel jobs Debugging jobs Lab exercises Test
Server Jobs : Pros and Cons Server Vs Parallel jobs Server jobs to PX Jobs ?? Architectural differences Different stages Plug Ins BASIC Programming Datastage Development Kit Performance Optimization in Server Jobs BASIC commands Universe and Unidata Stages Lab Exercises Test
Parallel Extender Overview : Parallel Extender – Its history More about Parallel Extender Orchestrate – Command Line options
Designing Parallel Jobs : Parallel Processing Pipeline and Partition Parallelism Partition Collecting Repartitioning Datasets Runtime Column Propagation Lab exercises
Parallel Job Stages: File stages Database stages Processing stages Debug stages Exercises
Advanced Parallel Extender Concepts : Partition and performance Operator specific User Defined Stages Environment Variables Datastage API Containers Buffering Stage Variables and Constraints Managing Datasets Orchestrate Commands for datasets Performance Tuning Test
Running Jobs :
Job properties and Parameters Job Sequences Performance Monitoring Print Messages JOB Monitor Debugging Dsrun - Command Line Options Parameter Files Automating using scripts Debugging, restart ability and Exception Handling Checkpoint/Restart Automatically Handling Aborts WaitForFile Stage Notify Stage Loops in sequencer User Variable Activity Exception handling and clean abort in Sequencer Notification can send email with attachments Scheduling and running jobs from UNIX Lab Exercises Test
Best Practices and Tips: Best Practices Templates Short cuts and time savers Performance Tuning
Live Project Example: Source to Staging Job development and testing Full Load and Incremental Load Stage to Presentation Layer – Loading Full end to end process Full test
|
