 |
|
|
|
|
|
|
Classifieds: Education / Training | | IBM WebSphere DataStage and QualityStage | | Posted By: Muralidhar Kamuni at: 6, Dec 2011 12:05:54 PM IST | IBM WebSphere DataStage and QualityStage - Version 8.1
Unit -1 : Data Warehouse Fundamentals
An introduction to Data Warehousing - purpose of Data Warehouse - Data Warehouse Architecture - Operational Data Store - OLTP Vs Warehouse Applications - Data Marts Data marts Vs Data Warehouses - Data Warehouse Life cycle .
Unit -2 : Data Modelling
Introduction to Data Modeling - Entity Relationship model (E-R model) - Data Modeling for Data Warehouse - Dimensions and fact tables - Star Schema and Snowflake Schemas.
Unit -3 : ETL Design Process
Introduction to Extraction, Transformation & Loading- Types of ETL Tools - Key tools in the market .
Unit -4 : Data Stage Installation
Data stage Installation - Prerequisites to install Data stage - Installation process.
Unit - 5 : Introduction to Datastage Version 8.1
Datastage introduction - IBM information Server architecture -- DataStage components - DataStage main functions - Client components.
Unit - 6 : Datastage Administrator
Datastage project Administration - Editing projects and Adding Projects - Deleting projects Cleansing up project files - Global variable setting - Environement management - Auto purging - Rutime Column Propagation(RCP) - Add checkpoints for sequencer - NLS configuration - Generated OSH (Orchestrate Engine) - System formats like date, timestamp - Project protect - Version details.
Unit - 7 : Datastage Director
Introduction to Datastage Director - Validating Datastage Jobs - Executing Datastage jobs - Job execution status - Monitoring a job - Job log view - job scheduling - Creating Batches - Scheduling batches.
Unit - 8 : Datastage Designer
Introduction to Datastage Designer - Importance of Parallelism - Pipeline Parallelism - Partition Parallelism - Partitioning and collecting - Partition techniques - Datastage Repository Palette - Passive and Active stages - Job design overview - Designer work area - Annotations - Creating jobs - Importing flat file definitions - Dataset Overview
Unit - 9 : Working with Parallel Job Stages
Database Stages
Oracle - Teradata - ODBC - dynamic RDBMS - DB2
File Stages
Sequential file - Dataset - File set - Lookup file set.
Processing Stages
Copy - Filter - Funnel - Sort Remove duplicate - Aggregator - Modify - Compress - Expand - Decode - Encode - Switch - Pivot stage - Lookup - Join - Merge - difference between look up, join and merge - change capture - Change apply - Compare - Difference - Surrogate key generator - Transformer.
Debug Stages
Head - Tail - Peek - Column generator - Row generator .
Real Time Stages
XML input - XML output -XML Transformer, Java packs, Webservice packs
Local and Shared containers
Unit - 10 Advanced Stages in Parallel Jobs (Version 8.1)
Range Look process - Surrogate key generator stage - Slowly changing dimension stage - iway stage - FTP stage - Java plug in - Job performance analysis - Resource estimation - Slowly Changing Dimensions implementation - Performance tuning.
Unit - 11 Job Sequencers
Arrange job activities in Sequencer - Triggers in Sequencer - Restablity - Recoverability - Notification activity - Terminator activity - Wait for file activity - Start Look activity - Execute Command activity - Nested Condition activity - Exception handling activity - User Variable activity - End Loop activity - Adding Checkpoints
Unit - 12 Information Analyzer
IBM WebShpere Information Analyzer overview - Data Profiling process - Column analysis - Primary key analysis - Foreign key analysis - Cross-domain analysis - Baseline analysis - Aanalysis result publication - Deleting statistics reports - Baseline analysis reports - Cross-domain analysis summary statistics reports - Beseline analysis reports - Cross-domain analysis reports - Primary key reports - Foregin key analysis reports.
Unit - 13 WebShpere Quality Stage
About Data Quality - Datastage quality stages - Investigate stage - Standardize stage Match Frequency stage - Unduplicate Match stage - Reference Match Stage - Survive stage.
Unit - 14 IBM Information Server Administration Guide
IBM WebSphere DataStage administration - Opening the IBM Information Server Web console - Creating users in the console - Assigning security roles to users and groups - Managing licenses - Managing active sessions - Managing logs - Managing schedules - Backing up and restoring IBM Information Server.
|
| |
More Education / Training classifieds |
|
|
|
|
|
| Advertisements |
|
|
|
|
| Advertisements |
|
